SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' );
SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' ); <table_name> : airport col : id | City | Country | IATA | ICAO | name row 1 : 1 | Akureyri | Iceland | AEY | BIAR | Akureyri Airport row 2 : 2 | Amsterdam | Netherlands | AMS | EHAM | Schiphol Airport row 3 : 3 | Anchorage | United States | ANC | PANC | Ted Stevens Airport row 4 : 4 | Baltimore | United States | BWI | KBWI | Baltimore-Washington Airport row 5 : 5 | Barcelona | Spain | BCN | LEBL | El Prat Airport row 6 : 6 | Bergen | Norway | BGO | ENBR | Bergen Airport row 7 : 7 | Billund | Denmark | BLL | EKBI | Billund Airport row 8 : 8 | Boston | United States | BOS | KBOS | Logan International Airport row 9 : 9 | Brussels | Belgium | BRU | EBBR | National Airport <table_name> : flight col : id | Vehicle_Flight_number | Date | Pilot | Velocity | Altitude | airport_id | company_id row 1 : 1 | M2-F1 #0 | 1963-03-01 00:00:00 | Thompson | 135 | 0 | 1 | 2 row 2 : 2 | M2-F1 #1 | 1963-08-16 00:00:00 | Thompson | 240 | 3650 | 2 | 3 row 3 : 3 | M2-F1 #6 | 1963-09-03 00:00:00 | Thompson | 240 | 3650 | 2 | 4 row 4 : 4 | M2-F1 #13 | 1963-10-25 00:00:00 | Thompson | 240 | 3650 | 3 | 4 row 5 : 5 | M2-F1 #14 | 1963-11-08 00:00:00 | Thompson | 240 | 3650 | 4 | 5 row 6 : 6 | M2-F1 #21 | 1964-01-29 00:00:00 | Thompson | 240 | 3650 | 4 | 6 row 7 : 7 | M2-F1 #33 | 1964-03-30 00:00:00 | Peterson | 240 | 3650 | 5 | 11 row 8 : 8 | M2-F1 #39 | 1964-05-19 00:00:00 | Peterson | 240 | 3650 | 2 | 13 row 9 : 9 | M2-F1 #61 | 1965-07-16 00:00:00 | Thompson | 240 | 3650 | 6 | 11 row 10 : 10 | M2-F1 #64 | 1965-08-30 00:00:00 | Thompson | 240 | 3650 | 9 | 1 row 11 : 11 | M2-F1 #70 | 1965-10-08 00:00:00 | Thompson | 240 | 3650 | 4 | 5 row 12 : 12 | M2-F1 #71 | 1966-03-28 00:00:00 | Thompson | 240 | 3650 | 6 | 7 row 13 : 13 | M2-F1 #73 | 1966-08-04 00:00:00 | Peterson | 240 | 3650 | 8 | 9
col : count(*) row 1 : 3