Show me the names of all the airports
select name from airport
What are the number of flights for each of these airports?
select name, count(*) from airport as t1 join flight as t2 on t1.id = t2.airport_id group by t1.id
Which airport had the most number of flights?
select t1.name from airport as t1 join flight as t2 on t1.id = t2.airport_id group by t1.id order by count(*) desc limit 1
Show me the id and IATA code of this airport as well.
select t1.id, t1.name, t1.iata from airport as t1 join flight as t2 on t1.id = t2.airport_id group by t1.id order by count(*) desc limit 1