CREATE TABLE activity (actid DECIMAL, activity_name TEXT)
CREATE TABLE participates_in (stuid DECIMAL, actid DECIMAL)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE faculty (facid DECIMAL, lname TEXT, fname TEXT, rank TEXT, sex TEXT, phone DECIMAL, room TEXT, building TEXT)
CREATE TABLE faculty_participates_in (facid DECIMAL, actid DECIMAL)

Which students are advised by Michael Goodrich? Give me their first and last names.
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" AS "T1" JOIN "student" AS "T2" ON "T1"."facid" = "T2"."advisor" WHERE "Goodrich" = "T1"."lname" AND "Michael" = "T1"."fname"