CREATE TABLE school (county VARCHAR2, enrollment NUMBER)

Show each county along with the number of schools and total enrollment in each county.
SELECT county, COUNT(*), SUM(enrollment) FROM school GROUP BY county
SELECT "county", COUNT(*), SUM("enrollment") FROM "school" GROUP BY "county"