CREATE TABLE Sportsinfo (gamesplayed INTEGER, sportname VARCHAR(255), onscholarship VARCHAR(255))
How many games are played for all football games by students on scholarship?
    
SQL: SELECT SUM(gamesplayed) FROM Sportsinfo WHERE sportname = "Football" AND onscholarship = 'Y'