CREATE TABLE premises (premises_type VARCHAR(255))
Show each premise type and the number of premises in that type.
    
SQL: SELECT premises_type, COUNT(*) FROM premises GROUP BY premises_type