CREATE TABLE Sportsinfo (gamesplayed INT, sportname VARCHAR, onscholarship VARCHAR)

How many games are played for all football games by students on scholarship?
SELECT SUM(gamesplayed) FROM Sportsinfo WHERE sportname = "Football" AND onscholarship = 'Y'
SELECT SUM("gamesplayed") FROM "Sportsinfo" WHERE "Football" = "sportname" AND "onscholarship" = 'Y'