CREATE TABLE flight (id DECIMAL, vehicle_flight_number TEXT, date TEXT, pilot TEXT, velocity DECIMAL, altitude DECIMAL, airport_id DECIMAL, company_id DECIMAL)
CREATE TABLE airport (id DECIMAL, city TEXT, country TEXT, iata TEXT, icao TEXT, name TEXT)
CREATE TABLE operate_company (id DECIMAL, name TEXT, type TEXT, principal_activities TEXT, incorporated_in TEXT, group_equity_shareholding DECIMAL)

How many airports haven't the pilot 'Thompson' driven an aircraft?
SELECT COUNT(*) FROM airport WHERE NOT id IN (SELECT airport_id FROM flight WHERE pilot = 'Thompson')
SELECT COUNT(*) FROM "airport" WHERE NOT "id" IN (SELECT "airport_id" FROM "flight" WHERE "pilot" = 'Thompson')