What is the total number of routes for each country and airline in that country?
select t1.country, t1.name, count(*) from airlines as t1 join routes as t2 on t1.alid = t2.alid group by t1.country, t1.name