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

Show all game ids and the number of hours played.
SELECT gameid, SUM(hours_played) FROM plays_games GROUP BY gameid
SELECT "gameid", SUM("hours_played") FROM "plays_games" GROUP BY "gameid"