CREATE TABLE department (school_code VARCHAR(255), dept_address VARCHAR(255))
How many different locations does each school have?
    
SQL: SELECT COUNT(DISTINCT dept_address), school_code FROM department GROUP BY school_code