Show first name and last name for all the students.
select fname, lname from student
Also show their advisor's first name and last name.
select t2.fname, t2.lname, t1.fname, t1.lname from faculty as t1 join student as t2 on t1.facid = t2.advisor
Who are 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"