CREATE TABLE Sportsinfo (sportname VARCHAR, onscholarship VARCHAR)

Which sport has most number of students on scholarship?
SELECT sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC LIMIT 1
SELECT "sportname" FROM "Sportsinfo" WHERE "onscholarship" = 'Y' GROUP BY "sportname" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1