SELECT count(DISTINCT dept_address) ,  school_code FROM department GROUP BY school_code
Count different addresses of each school.
SELECT count ( DISTINCT dept_address ) , school_code FROM department GROUP BY school_code
select count ( distinct dept_address ) , school_code from department group by school_code
Count different addresses of each school .