instruction: Return a bar chart on how many departments are in each school?, and list by the count(DISTINCTdept_name) in ascending.
response: SELECT SCHOOL_CODE, COUNT(DISTINCT DEPT_NAME) FROM DEPARTMENT ORDER BY COUNT(DISTINCT DEPT_NAME)