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
Show the locations of schools that have more than 1 player.
assistant
SELECT T2.Location FROM player AS T1 JOIN school AS T2 ON T1.School_ID = T2.School_ID GROUP BY T1.School_ID HAVING COUNT(*) > 1
human
How many schools are there?
assistant
SELECT count(*) FROM school
human
What are the enrollments of schools whose denomination is not 'Catholic'?
assistant
SELECT Enrollment FROM school WHERE Denomination != 'Catholic'
human
List the school color of the school that has the largest enrollment.
assistant
SELECT School_Colors FROM school ORDER BY Enrollment DESC LIMIT 1
human
List the locations of schools in ascending order of enrollment.
assistant
SELECT LOCATION FROM school ORDER BY Enrollment ASC
human
Take the average of the school enrollment.
assistant
SELECT avg ( Enrollment ) FROM school ;