what are the different active codes?
select distinct active from airlines
show the name of airlines whose active status is 'Y'.
select name from airlines where active = 'Y'
Which country has the largest number of these airlines?
select country from airlines where active = 'Y' group by country order by count(*) desc limit 1