Show the type of school and the number of buses for each type.
create table school (type varchar, school_id varchar, PRIMARY KEY (type)); create table school_bus (school_id varchar, PRIMARY KEY (school_id))
select t2.type, count(*) from school_bus as t1 join school as t2 on t1.school_id = t2.school_id group by t2.type