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