How many different locations does each school have?
create table department (school_code varchar, dept_address varchar, PRIMARY KEY (school_code))
select count(distinct dept_address), school_code from department group by school_code