Database: flight_company
Question: How many airports haven't the pilot 'Thompson' driven an aircraft?
SQL:
SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' );