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

What are the names of all games played by Linda Smith?
SELECT gname FROM plays_games AS T1 JOIN video_games AS T2 ON T1.gameid = T2.gameid JOIN student AS T3 ON T3.stuid = T1.stuid WHERE T3.lname = "Smith" AND T3.fname = "Linda"
SELECT "gname" FROM "plays_games" "T1" JOIN "video_games" "T2" ON "T1"."gameid" = "T2"."gameid" JOIN "student" "T3" ON "Linda" = "T3"."fname" AND "Smith" = "T3"."lname" AND "T1"."stuid" = "T3"."stuid"