Show each premise type and the number of premises in that type.
create table premises (premises_type varchar, PRIMARY KEY (premises_type))
select premises_type, count(*) from premises group by premises_type