CREATE TABLE Plays_games (gameid VARCHAR2)
CREATE TABLE Video_games (gameid VARCHAR2)

Show all game names played by at least 1000 hours.
SELECT gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid = T2.gameid GROUP BY T1.gameid HAVING SUM(hours_played) >= 1000
SELECT "gname" FROM "Plays_games" "T1" JOIN "Video_games" "T2" ON "T1"."gameid" = "T2"."gameid" GROUP BY "T1"."gameid" HAVING SUM("hours_played") >= 1000