Database: college_1
Question: How many different locations does each school have?
SQL:
SELECT count(DISTINCT dept_address) ,  school_code FROM department GROUP BY school_code