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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show all student IDs with the number of sports and total number of games played ### Input: CREATE TABLE Sportsinfo (
    StuID VARCHAR,
    gamesplayed INTEGER
) ### Response: SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID