CREATE TABLE airport (id VARCHAR(255), airport_id VARCHAR(255), pilot VARCHAR(255)); CREATE TABLE flight (id VARCHAR(255), airport_id VARCHAR(255), pilot VARCHAR(255))
How many airports haven't the pilot 'Thompson' driven an aircraft?
    
SQL: SELECT COUNT(*) FROM airport WHERE NOT id IN (SELECT airport_id FROM flight WHERE pilot = 'Thompson')