How many games are played for all football games by students on scholarship?
CREATE TABLE Sportsinfo (
    gamesplayed INTEGER,
    sportname VARCHAR,
    onscholarship VARCHAR
)
SELECT SUM(gamesplayed) FROM Sportsinfo WHERE sportname = "Football" AND onscholarship = 'Y'
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: How many games are played for all football games by students on scholarship? ### Input: CREATE TABLE Sportsinfo (
    gamesplayed INTEGER,
    sportname VARCHAR,
    onscholarship VARCHAR
) ### Response: SELECT SUM(gamesplayed) FROM Sportsinfo WHERE sportname = "Football" AND onscholarship = 'Y'