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