Can you show me the average enrollment of all schools?
select avg ( enrollment ) from school
Can you show me the maximum enrollment of all schools?
select max ( enrollment ) from school
Can you show me the minimum enrollment of all schools?
select min ( enrollment ) from school
What is the name of the school with the maximum enrollment?
select school_name from school order by enrollment desc limit 1
What is the name of the school with the minimum enrollment?
select school_name from school order by enrollment limit 1