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 sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)
CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)

What are the ids of all students along with how many sports and games did they play?
SELECT stuid, COUNT(*), SUM(gamesplayed) FROM sportsinfo GROUP BY stuid
SELECT "stuid", COUNT(*), SUM("gamesplayed") FROM "sportsinfo" GROUP BY "stuid"