What are the different schools?
select distinct school_code from department
How many departments does each one of them have?
select count(distinct dept_name), school_code from department group by school_code
Find the ones which have less than 5 deparments.
select count(distinct dept_name), school_code from department group by school_code having count(distinct dept_name) < 5