CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INT)

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"