CREATE TABLE Plays_Games (StuID NUMBER, GameID NUMBER, Hours_Played NUMBER)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)
CREATE TABLE SportsInfo (StuID NUMBER, SportName VARCHAR2, HoursPerWeek NUMBER, GamesPlayed NUMBER, OnScholarship VARCHAR2)
CREATE TABLE Video_Games (GameID NUMBER, GName VARCHAR2, GType VARCHAR2)

What are ids and total number of hours played for each game.
SELECT GameID, SUM(Hours_Played) FROM Plays_Games GROUP BY GameID
SELECT "GameID", SUM("Hours_Played") FROM "Plays_Games" GROUP BY "GameID"