Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE endowment ( endowment_id int, School_id int, donator_name text, amount real )
TABLE: CREATE TABLE School ( School_id text, School_name text, Location text, Mascot text, Enrollment int, IHSAA_Class text, IHSAA_Football_Class text, County text )
TABLE: 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 )

### Question ###
Please give me a bar chart for the total enrollment in each county, and order by the sum enrollment in desc.

### Accurate SQL ###

SELECT County, SUM(Enrollment) FROM School GROUP BY County ORDER BY SUM(Enrollment) DESC