SELECT sum(gamesplayed) FROM Sportsinfo WHERE sportname  =  "Football" AND onscholarship  =  'Y'
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 sportname = value and onscholarship = value
How many games are played for all football games by students on scholarship ?