list number of games played by students
select sum ( gamesplayed ) from sportsinfo
how many of those are played by students on scholarship?
select sum ( gamesplayed ) from sportsinfo where onscholarship = 'Y'
list all the names of the sports available
select distinct sportname from sportsinfo