how many of those are played by students on scholarship?
SELECT sum ( gamesplayed )  FROM Sportsinfo WHERE onscholarship   =   'Y'
played by students on scholarship refers to onscholarship = 'Y'; sum of those refers to SUM(gamesplayed);