SELECT count(DISTINCT dept_name) ,  school_code FROM department GROUP BY school_code HAVING count(DISTINCT dept_name)  <  5
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 ) < value
Find the number of different departments in each school whose number of different departments is less than 5 .