CREATE TABLE Student (advisor VARCHAR2, fname VARCHAR2, lname VARCHAR2)
CREATE TABLE Faculty (fname VARCHAR2, lname VARCHAR2, FacID VARCHAR2)

What are the first name and last name of Linda Smith's advisor?
SELECT T1.fname, T1.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.advisor WHERE T2.fname = "Linda" AND T2.lname = "Smith"
SELECT "T1"."fname", "T1"."lname" FROM "Faculty" "T1" JOIN "Student" "T2" ON "Linda" = "T2"."fname" AND "Smith" = "T2"."lname" AND "T1"."FacID" = "T2"."advisor"