CREATE TABLE sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE plays_games (stuid DECIMAL, gameid DECIMAL, hours_played DECIMAL)
CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)

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"