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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE premises (premises_type VARCHAR) Question: Show each premise type and the number of premises in that type. [/INST] SELECT premises_type, COUNT(*) FROM premises GROUP BY premises_type </s>