Which sport has most number of students on scholarship?
CREATE TABLE Sportsinfo (sportname VARCHAR, onscholarship VARCHAR)
SELECT TOP 1 sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Sportsinfo (sportname VARCHAR, onscholarship VARCHAR) Question: Which sport has most number of students on scholarship? [/INST] SELECT TOP 1 sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC </s>