How many games has each student played?
select gamesplayed from sportsinfo
Which of those refer to football games played by scholarship students?
select gamesplayed from sportsinfo where sportname = "Football" and onscholarship = 'Y'
What is the total number of those games played?
select sum(gamesplayed) from sportsinfo where sportname = "Football" and onscholarship = 'Y'