How many airports has pilot Thompson driven an aircraft?
SELECT count ( * )  FROM airport WHERE id IN  (  SELECT airport_id FROM flight WHERE pilot   =   'Thompson'  ) 
count of airports = COUNT(*); Thompson has driven an aircraft refers to pilot = 'Thompson';