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
For each country and airline name, how many routes are there?
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
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
For each country and airline name , how many routes are there ?