How many games are played for all football games by students on scholarship?
create table sportsinfo (gamesplayed integer, sportname varchar, onscholarship varchar, PRIMARY KEY (gamesplayed))
select sum(gamesplayed) from sportsinfo where sportname = "football" and onscholarship = 'y'