What are all the source airports?
select t2.src_apid,t2.src_ap,t1.name from airports as t1 join routes as t2 on t1.apid = t2.src_apid group by t1.name
Yes please.
select count ( * ) from airports as t1 join routes as t2 on t1.apid = t2.src_apid group by t1.name
What are the names of the airports associated with each number of routes?
select t1.name, count ( * ) from airports as t1 join routes as t2 on t1.apid = t2.src_apid group by t1.name