instruction: Draw a bar chart for how many different locations does each school have?, I want to list X-axis in ascending order.
response: SELECT SCHOOL_CODE, COUNT(DISTINCT DEPT_ADDRESS) FROM DEPARTMENT ORDER BY SCHOOL_CODE