CREATE TABLE plays_games (stuid NUMBER, gameid NUMBER, hours_played NUMBER)
CREATE TABLE sportsinfo (stuid NUMBER, sportname CLOB, hoursperweek NUMBER, gamesplayed NUMBER, onscholarship CLOB)
CREATE TABLE video_games (gameid NUMBER, gname CLOB, gtype CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)

Show the game name that has most number of 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
SELECT "gname" FROM "plays_games" "T1" JOIN "video_games" "T2" ON "T1"."gameid" = "T2"."gameid" GROUP BY "T1"."gameid" ORDER BY SUM("hours_played") DESC FETCH FIRST 1 ROWS ONLY