How many hours did each student play for each game?
select hours_played from plays_games group by gameid
What is the toal number of hours played for each game?
select sum(hours_played) from plays_games group by gameid
And what is the id of each game?
select gameid, sum(hours_played) from plays_games group by gameid