instruction: how many students are advised by each rank of faculty? List the rank and the number of students, order by the the total number from high to low.
response: SELECT Rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.Advisor GROUP BY T1.Rank ORDER BY COUNT(*) DESC