Database: game_1
Question: 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'