Show the student ids.
select stuid from student
Also show the ranks of their advisors.
select t2.stuid, t1.rank from faculty as t1 join student as t2 on t1.facid = t2.advisor
Show the student id for those whose advisors are professors?
select t2.stuid from faculty as t1 join student as t2 on t1.facid = t2.advisor where t1.rank = "Professor"