SELECT country FROM airlines WHERE active  =  'Y' GROUP BY country ORDER BY count(*) DESC LIMIT 1
What are the countries with the most airlines whose active status is Y?
SELECT country FROM airlines WHERE active = 'Y ' GROUP BY country ORDER BY count ( * ) DESC LIMIT 1
select country from airlines where active = value group by country order by count ( * ) desc limit value
What are the countries with the most airlines whose active status is Y ?