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

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