What are the mascots for schools with enrollments above the average?
SELECT mascot FROM school WHERE enrollment  >  (SELECT avg(enrollment) FROM school)
mascots for schools with enrollments above the average refers to SELECT mascot FROM school WHERE enrollment > (SELECT AVG(enrollment) FROM school);