how many flights have pilot Thompson flown?
select count ( * ) from flight where pilot = 'Thompson'
What are the names of those airports?
select name from airport where id not in ( select airport_id from flight where pilot = 'Thompson' )