Database: flight_4
Question: For the airline ids with the top 10 most routes operated, what are their names?
SQL:
SELECT T1.name ,  T2.alid FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T2.alid ORDER BY count(*) DESC LIMIT 10