What are all the names of the pilots who flew a flight in the United States?
select distinct t2.pilot from airport as t1 join flight as t2 on t1.id = t2.airport_id where t1.country = 'United States'
What are the names of all the pilots who flew a flight in the Billund Airport?
select distinct t2.pilot from airport as t1 join flight as t2 on t1.id = t2.airport_id where t1.name = 'Billund Airport'
Can you list the names and velocities of all pilots who flew out of Ted Stevens Airport?
select t2.pilot, t2.velocity from airport as t1 join flight as t2 on t1.id = t2.airport_id where t1.name = 'Ted stevens Airport'