Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM flight WHERE Pilot ! = "Thompson"
Feedback: Need to count airports .
Output (English): SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' )