Show me a list of all the different airports!
select * from airport
What ones have more than 10000000 total passengers?
select * from airport where total_passengers > 10000000
Show all the aircrafts associated with each of these airports.
select * from aircraft as t1 join airport_aircraft as t2 on t1.aircraft_id = t2.aircraft_id join airport as t3 on t2.airport_id = t3.airport_id where t3.total_passengers > 10000000
Show only the names and descriptions.
select t1.aircraft, t1.description from aircraft as t1 join airport_aircraft as t2 on t1.aircraft_id = t2.aircraft_id join airport as t3 on t2.airport_id = t3.airport_id where t3.total_passengers > 10000000