I want to know the names of advisors available
select fname, lname from faculty
Could you tell me the names of advisors for female students?
select t2.fname, t2.lname from student as t1 join faculty as t2 on t2.facid = t1.advisor where t1.sex = "F"
What about the name of the advisor for the student named Linda Smith?
select t2.fname, t2.lname from student as t1 join faculty as t2 on t2.facid = t1.advisor where t1.fname = "Linda" and t1.lname = "Smith"