Find the number of routes for each source airport and the airport name.
create table airports (name varchar, apid varchar, PRIMARY KEY (name)); create table routes (src_apid varchar, PRIMARY KEY (src_apid))
select count(*), t1.name from airports as t1 join routes as t2 on t1.apid = t2.src_apid group by t1.name