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

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" "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"