Show first name and last name for all the students advised by Michael Goodrich.
CREATE TABLE Faculty (
    FacID VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE Student (
    fname VARCHAR,
    lname VARCHAR,
    advisor VARCHAR
)
SELECT T2.fname, T2.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.advisor WHERE T1.fname = "Michael" AND T1.lname = "Goodrich"
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: Show first name and last name for all the students advised by Michael Goodrich. ### Input: CREATE TABLE Faculty (
    FacID VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE Student (
    fname VARCHAR,
    lname VARCHAR,
    advisor VARCHAR
) ### Response: SELECT T2.fname, T2.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.advisor WHERE T1.fname = "Michael" AND T1.lname = "Goodrich"