How many airports has pilot Thompson driven an aircraft?
select count ( * ) from airport where id in ( select airport_id from flight where pilot = 'Thompson' )
How many airports had Thompson driven by August 1963?
select count ( * ) from airport as t1 join flight as t2 on t1.id = t2.airport_id where t2.pilot = 'Thompson' and t2.date > 'August 16, 1963'
What is the flight number of the aircraft Thompson drove in  March 1, 1963
select vehicle_flight_number from flight where pilot = 'Thompson' and date = 'March 1, 1963'