SELECT premises_type ,  count(*) FROM premises GROUP BY premises_type
Show each premise type and the number of premises in that type.
SELECT premises_type , count ( * ) FROM premises GROUP BY premises_type
select premises_type , count ( * ) from premises group by premises_type
Show each premise type and the number of premises in that type .