SELECT COUNT(DISTINCT dept_address), school_code FROM department GROUP BY school_code
Berapa banyak lokasi berbeda yang dimiliki setiap sekolah?
CREATE TABLE department (school_code VARCHAR, dept_address VARCHAR)