Hello!  Can you first give me a list of all of the countries?
select country from airlines
Great!  Which of these countries has the most airlines with an Active status of "Y"?
select country from airlines where active = 'Y' group by country order by count ( * ) desc limit 1
Can you tell me what is the total number of airlines in the United States that have an active status of "Y"?
select count ( * ) from airlines where active = 'Y' and country = "United States"