human
Schema:
School (School_id, School_name, Location, Mascot, Enrollment, IHSAA_Class, IHSAA_Football_Class, County)
budget (School_id, Year, Budgeted, total_budget_percent_budgeted, Invested, total_budget_percent_invested, Budget_invested_percent)
endowment (endowment_id, School_id, donator_name, amount)
Please answer with SQL.
assistant
Sure, I understand.
human
Can you show me the average enrollment of all schools?
assistant
SELECT AVG ( enrollment ) FROM school;
human
Can you show me the maximum enrollment of all schools?
assistant
SELECT MAX( enrollment ) FROM school;
human
Can you show me the minimum enrollment of all schools?
assistant
SELECT MIN( enrollment ) FROM school;
human
What is the name of the school with the maximum enrollment?
assistant
SELECT School_name FROM school ORDER by Enrollment desc LIMIT 1;
human
What is the name of the school with the minimum enrollment?
assistant
SELECT School_name FROM school ORDER by Enrollment LIMIT 1 ;