Quais são os mascotes das escolas com matrículas acima da média?
CREATE TABLE school (mascot VARCHAR, enrollment INTEGER)
SELECT mascot FROM school WHERE enrollment > (SELECT AVG(enrollment) FROM school)