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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Which sport has most number of students on scholarship? ### Input: CREATE TABLE Sportsinfo (
    sportname VARCHAR,
    onscholarship VARCHAR
) ### Response: SELECT sportname FROM Sportsinfo WHERE onscholarship = 'Y' GROUP BY sportname ORDER BY COUNT(*) DESC LIMIT 1