What is the name of each game from its id?
select gname from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid group by t1.gameid
Order the names by total hours played.
select gname from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid group by t1.gameid order by sum(hours_played) desc
which one is first?
select gname from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid group by t1.gameid order by sum(hours_played) desc limit 1