instruction: For each faculty rank, show the number of faculty members who have it Show bar chart, and could you show total number from low to high order please?
response: SELECT Rank, COUNT(*) FROM Faculty GROUP BY Rank ORDER BY COUNT(*)