How many different locations does each school have?
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(DISTINCT dept_address)': 7, 'SCHOOL_CODE': 'A&SCI'}, {'count(DISTINCT dept_address)': 4, 'SCHOOL_CODE': 'BUS'}]