instruction: How many students are advised by each rank of faculty? List the rank and the number of students.
response: SELECT T1.rank, COUNT(*) FROM faculty AS T1 JOIN student AS T2 ON T1.facid = T2.advisor GROUP BY T1.rank