Task: Text to Code
Input (English): SQL: SELECT country , Count ( * ) FROM airports GROUP BY country
Feedback: find name , country from airlines table , ensure each rows correspond airline id of routes table .
Output (English): 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