Show the first name and last name for all Faculty.
select fname, lname from faculty
Also show the names of students that each one advises.
select t1.fname, t1.lname, t2.fname, t2.lname from faculty as t1 join student as t2 on t1.facid = t2.advisor
Who is Linda Smith's advisor?
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"