Database: game_1
Question: Show all student IDs with the number of sports and total number of games played
SQL:
SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID