Database: college_1
Question: Find the number of different departments in each school whose number of different departments is less than 5.
SQL:
SELECT count(DISTINCT dept_name) ,  school_code FROM department GROUP BY school_code HAVING count(DISTINCT dept_name)  <  5