CREATE TABLE Student (Stuid VARCHAR, Lname VARCHAR, Fname VARCHAR)
CREATE TABLE Video_games (gameid VARCHAR)
CREATE TABLE Plays_games (gameid VARCHAR, Stuid VARCHAR)

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"