instruction: Show all the faculty ranks and the number of students advised by each rank Visualize by bar chart, order in asc by the X-axis.
response: SELECT Rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.Advisor GROUP BY T1.Rank ORDER BY Rank