CREATE TABLE department (school_code VARCHAR, dept_name VARCHAR)
SELECT COUNT(DISTINCT dept_name), school_code FROM department GROUP BY school_code
ค้นหาจำนวนแผนกในแต่ละโรงเรียน
Find the number of departments in each school.