CREATE TABLE Plays_games (gameid VARCHAR, hours_played INT)

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"