Which sport has most number of students on scholarship?
CREATE TABLE Sportsinfo (sportname VARCHAR, onscholarship VARCHAR)
SELECT sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC LIMIT 1
### Context: CREATE TABLE Sportsinfo (sportname VARCHAR, onscholarship VARCHAR) ### Question: Which sport has most number of students on scholarship? ### Answer: SELECT sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC LIMIT 1