CREATE TABLE department (school_code VARCHAR, dept_address VARCHAR)
SELECT COUNT(DISTINCT dept_address), school_code FROM department GROUP BY school_code
แต่ละโรงเรียนมีสถานที่ต่างกันกี่แห่ง?
How many different locations does each school have?