Can you list all schools with less than 5 different departments?
select school_code from department group by school_code having count ( distinct dept_name ) < 5
Can you list all the departments with the school code BUS?
select * from department where school_code = "BUS"
Thanks, can you just show the number of different departments in the table?
select count ( distinct dept_name ), school_code from department group by school_code having count ( distinct dept_name ) < 5