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
### Context: CREATE TABLE school (county VARCHAR, enrollment INTEGER) ### Question: Show each county along with the number of schools and total enrollment in each county. ### Answer: SELECT county, COUNT(*), SUM(enrollment) FROM school GROUP BY county