How many students were advised by professors?
select count ( * ) from faculty as t1 join student as t2 on t1.facid = t2.advisor where t1.rank = "Professor"
How many students were advised by instructors ?
select count ( * ) from faculty as t1 join student as t2 on t1.facid = t2.advisor where t1.rank = "Instructor"