SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID
Show all student IDs with the number of sports and total number of games played
SELECT StuID , count ( * ) , sum ( gamesplayed ) FROM Sportsinfo GROUP BY StuID
select stuid , count ( * ) , sum ( gamesplayed ) from sportsinfo group by stuid
Show all student IDs with the number of sports and total number of games played