How many airports haven't the pilot 'Thompson' driven an aircraft?
create table airport (id varchar, airport_id varchar, pilot varchar, PRIMARY KEY (id)); create table flight (id varchar, airport_id varchar, pilot varchar, PRIMARY KEY (id))
select count(*) from airport where not id in (select airport_id from flight where pilot = 'thompson')