How many sports does each student play?
select count(*) from sportsinfo group by stuid
Also, how many games has each student played?
select count(*), sum(gamesplayed) from sportsinfo group by stuid
Also, what are their different student ids?
select stuid, count(*), sum(gamesplayed) from sportsinfo group by stuid