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

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"