For each airport name, how many routes start at that airport?
select count(*), t1.name from airports as t1 join routes as t2 on t1.apid = t2.src_apid group by t1.name