Which countries have the most number of airlines whose active status is Y?
select country from airlines where active = 'Y' group by country order by count ( * ) desc limit 1
What is the airline id of Aloha Airlines?
select alid from airlines where name = 'Aloha Airlines'
What's the call sign of airline id 5?
select callsign from airlines where alid = 5