Show all student IDs with the number of sports and total number of games played
CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INTEGER)
SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID
### Context: CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INTEGER) ### Question: Show all student IDs with the number of sports and total number of games played ### Answer: SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID