Which students have professors as their advisors? Find their student ids.
select t2.stuid from faculty as t1 join student as t2 on t1.facid = t2.advisor where t1.rank = "Professor"