Show all the faculty ranks and the number of students advised by each rank.
select t1.rank, count(*) from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.rank