How many tourists did not make any visit?
create table visitors (tourist_id varchar, PRIMARY KEY (tourist_id)); create table visits (tourist_id varchar, PRIMARY KEY (tourist_id))
select count(*) from visitors where not tourist_id in (select tourist_id from visits)