Which countries has the most number of airlines whose active status is 'Y'?
CREATE TABLE airlines (country VARCHAR, active VARCHAR)
SELECT TOP 1 country FROM airlines WHERE active = 'Y' GROUP BY country ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE airlines (country VARCHAR, active VARCHAR) Question: Which countries has the most number of airlines whose active status is 'Y'? [/INST] SELECT TOP 1 country FROM airlines WHERE active = 'Y' GROUP BY country ORDER BY COUNT(*) DESC </s>