Provide the names of all airlines.
select name from airlines
Find the number of routes provided by each airline. Show airline name.
select count(*), t1.name from airlines as t1 join routes as t2 on t1.alid = t2.alid group by t1.name
which airline operates the most routes?
select t1.name from airlines as t1 join routes as t2 on t1.alid = t2.alid group by t2.alid order by count(*) desc limit 1
what are the top 10 airlines?
select t1.name from airlines as t1 join routes as t2 on t1.alid = t2.alid group by t2.alid order by count(*) desc limit 10