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

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" AS "T1" JOIN "video_games" AS "T2" ON "T1"."gameid" = "T2"."gameid" JOIN "student" AS "T3" ON "Linda" = "T3"."fname" AND "Smith" = "T3"."lname" AND "T1"."stuid" = "T3"."stuid"