CREATE TABLE Student (advisor VARCHAR(255), fname VARCHAR(255), lname VARCHAR(255)); CREATE TABLE Faculty (fname VARCHAR(255), lname VARCHAR(255), FacID VARCHAR(255))
What are the first name and last name of Linda Smith's advisor?
    
SQL: 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"