How many students are advised by each rank of faculty? List the rank and the number of students.
select t1.rank, count(*) from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.rank