Database: game_1
Question: What are the ids of all students along with how many sports and games did they play?
SQL:
SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID