Who is the advisor of Linda Smith? Give me the first name and last name.
CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE faculty_participates_in (
    facid number,
    actid number
)

CREATE TABLE participates_in (
    stuid number,
    actid number
)

CREATE TABLE faculty (
    facid number,
    lname text,
    fname text,
    rank text,
    sex text,
    phone number,
    room text,
    building text
)

CREATE TABLE activity (
    actid number,
    activity_name text
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who is the advisor of Linda Smith? Give me the first name and last name. ### Input: CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE faculty_participates_in (
    facid number,
    actid number
)

CREATE TABLE participates_in (
    stuid number,
    actid number
)

CREATE TABLE faculty (
    facid number,
    lname text,
    fname text,
    rank text,
    sex text,
    phone number,
    room text,
    building text
)

CREATE TABLE activity (
    actid number,
    activity_name text
) ### Response: 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"