How many hours of role-playing games were played?
select sum ( hours_played ) from plays_games as t1 join video_games where gtype = "Role-playing game"
What game had the most 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 limit 1
Who played the most hours of Works of Widenius?
select stuid from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid where t2.gname = "Works of Widenius" order by hours_played desc limit 1
How many students play Works of Widenius?
select count ( distinct t1.stuid ) from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid where t2.gname = "Works of Widenius"
What game type is Works of Widenius?
select gtype from video_games where gname = "Works of Widenius"