instruction: Find the number of departments in each school Plot them as bar chart, and I want to show by the y axis from high to low please.
response: SELECT SCHOOL_CODE, COUNT(DISTINCT DEPT_NAME) FROM DEPARTMENT ORDER BY COUNT(DISTINCT DEPT_NAME) DESC