SELECT County, SUM(Enrollment) FROM School GROUP BY County
Show sum enrollment from each county
CREATE TABLE School (
    School_id text,
    School_name text,
    Location text,
    Mascot text,
    Enrollment int,
    IHSAA_Class text,
    IHSAA_Football_Class text,
    County text
)

CREATE TABLE endowment (
    endowment_id int,
    School_id int,
    donator_name text,
    amount real
)

CREATE TABLE budget (
    School_id int,
    Year int,
    Budgeted int,
    total_budget_percent_budgeted real,
    Invested int,
    total_budget_percent_invested real,
    Budget_invested_percent text
)