CREATE TABLE school_performance (school_id NUMBER, school_year CLOB, class_a CLOB, class_aa CLOB)
CREATE TABLE player (player_id NUMBER, player CLOB, team CLOB, age NUMBER, position CLOB, school_id NUMBER)
CREATE TABLE school (school_id NUMBER, school CLOB, location CLOB, enrollment NUMBER, founded NUMBER, denomination CLOB, boys_or_girls CLOB, day_or_boarding CLOB, year_entered_competition NUMBER, school_colors CLOB)
CREATE TABLE school_details (school_id NUMBER, nickname CLOB, colors CLOB, league CLOB, class CLOB, division CLOB)

List the locations of schools in ascending order of enrollment.
SELECT location FROM school ORDER BY enrollment
SELECT "location" FROM "school" ORDER BY "enrollment"