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)
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 endowment (endowment_id NUMBER, School_id NUMBER, donator_name CLOB, amount FLOAT)

Plot the number of schools and total enrollment in each county with a scatter chart.
SELECT COUNT(*), SUM(Enrollment) FROM School GROUP BY County
SELECT COUNT(*), SUM("Enrollment") FROM "School" GROUP BY "County"