CREATE TABLE department (school_code VARCHAR2, dept_name VARCHAR2)

Find the number of different departments in each school whose number of different departments is less than 5.
SELECT COUNT(DISTINCT dept_name), school_code FROM department GROUP BY school_code HAVING COUNT(DISTINCT dept_name) < 5
SELECT COUNT(DISTINCT "dept_name"), "school_code" FROM "department" GROUP BY "school_code" HAVING COUNT(DISTINCT "dept_name") < 5