human
Schema:
school (School_ID, School, Location, Enrollment, Founded, Denomination, Boys_or_Girls, Day_or_Boarding, Year_Entered_Competition, School_Colors)
school_details (School_ID, Nickname, Colors, League, Class, Division)
school_performance (School_Id, School_Year, Class_A, Class_AA)
player (Player_ID, Player, Team, Age, Position, School_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
Please show different denominations and the corresponding number of schools in descending order.
assistant
SELECT Denomination , COUNT(*) FROM school GROUP BY Denomination ORDER BY COUNT(*) DESC
human
List the locations of schools in descending order of founded year.
assistant
SELECT LOCATION FROM school ORDER BY Founded DESC
human
How many schools are there?
assistant
SELECT count(*) FROM school
human
List the locations of schools in ascending order of enrollment.
assistant
SELECT LOCATION FROM school ORDER BY Enrollment ASC
human
What is the average enrollment of schools?
assistant
SELECT avg(Enrollment) FROM school
human
What is the school color of the school with the largest enrollment?
assistant
SELECT School_Colors FROM school ORDER BY Enrollment DESC LIMIT 1 ;