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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Plays_games (gameid VARCHAR, hours_played INTEGER) Question: Show all game ids and the number of hours played. [/INST] SELECT gameid, SUM(hours_played) FROM Plays_games GROUP BY gameid </s>