CREATE TABLE premises (premises_type VARCHAR)

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"