List the names of all the pilots.
select distinct pilot from flight
Which companies did Thompson fly for?
select distinct t2.name from flight as t1 join operate_company as t2 on t1.company_id = t2.id and t1.pilot = 'Thompson'
List all the airports where he drove an aircraft.
select distinct t2.name from flight as t1 join airport as t2 on t1.airport_id = t2.id and t1.pilot = 'Thompson'
What is the total number of airports where he has not driven an aircraft?
select count(*) from airport where id not in ( select airport_id from flight where pilot = 'Thompson' );