CREATE TABLE endowment (endowment_id NUMBER, School_id NUMBER, donator_name CLOB, amount FLOAT)
CREATE TABLE School (School_id CLOB, School_name CLOB, Location CLOB, Mascot CLOB, Enrollment NUMBER, IHSAA_Class CLOB, IHSAA_Football_Class CLOB, County CLOB)
CREATE TABLE budget (School_id NUMBER, Year NUMBER, Budgeted NUMBER, total_budget_percent_budgeted FLOAT, Invested NUMBER, total_budget_percent_invested FLOAT, Budget_invested_percent CLOB)

What is the proportion of the number of schools in different counties?
SELECT County, COUNT(*) FROM School GROUP BY County
SELECT "County", COUNT(*) FROM "School" GROUP BY "County"