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

Show all game names 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"