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

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"