Task: Text to Code
Input (English): How many airports haven't the pilot 'Thompson' driven an aircraft?
Output (English): SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' )