SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID
What are the ids of all students along with how many sports and games did they play?
SELECT StuID , count ( * ) , sum ( gamesplayed ) FROM Sportsinfo GROUP BY StuID
select stuid , count ( * ) , sum ( gamesplayed ) from sportsinfo group by stuid
What are the ids of all students along with how many sports and games did they play ?