CREATE TABLE department (school_code VARCHAR(255), dept_name VARCHAR(255))
Find the number of departments in each school.
    
SQL: SELECT COUNT(DISTINCT dept_name), school_code FROM department GROUP BY school_code