###HUMAN: Visualize a bar chart for how many students are in each department?, and could you sort y axis in descending order?, ###ASSISTANT: SELECT dept_name, COUNT(*) FROM student GROUP BY dept_name ORDER BY COUNT(*) DESC