SCHEMA:
CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INTEGER)
USER:
Show all student IDs with the number of sports and total number of games played

QUERY:
SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID