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