Show all game ids and the number of hours played.
CREATE TABLE Plays_games (gameid VARCHAR, hours_played INTEGER)
SELECT gameid, SUM(hours_played) FROM Plays_games GROUP BY gameid
### Context: CREATE TABLE Plays_games (gameid VARCHAR, hours_played INTEGER) ### Question: Show all game ids and the number of hours played. ### Answer: SELECT gameid, SUM(hours_played) FROM Plays_games GROUP BY gameid