SELECT Stuid ,  sum(hours_played) FROM Plays_games GROUP BY Stuid
SELECT Stuid ,  sum(hours_played) FROM Plays_games GROUP BY Stuid <table_name> : Plays_Games col : StuID | GameID | Hours_Played row 1 : 1001 | 1 | 35 row 2 : 1001 | 2 | 15 row 3 : 1001 | 5 | 1 row 4 : 1007 | 4 | 1000 row 5 : 1008 | 5 | 50 row 6 : 1008 | 3 | 50 row 7 : 1010 | 6 | 1337 row 8 : 1032 | 1 | 47 row 9 : 1032 | 2 | 10 row 10 : 1032 | 3 | 100
col : StuID | sum(hours_played) row 1 : 1001 | 51 row 2 : 1007 | 1000 row 3 : 1008 | 100 row 4 : 1010 | 1337 row 5 : 1032 | 157