SELECT count(*) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )
How many tourists did not make any visit?
SELECT count ( * ) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )
select count ( * ) from visitors where tourist_id not in ( select tourist_id from visits )
How many tourists did not make any visit ?