Show institution types, along with the number of institutions and total enrollment for each type.
CREATE TABLE institution (TYPE VARCHAR, enrollment INTEGER)
SELECT TYPE, COUNT(*), SUM(enrollment) FROM institution GROUP BY TYPE
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE institution (TYPE VARCHAR, enrollment INTEGER) Question: Show institution types, along with the number of institutions and total enrollment for each type. [/INST] SELECT TYPE, COUNT(*), SUM(enrollment) FROM institution GROUP BY TYPE </s>