I want to know that what are the mascots for schools with enrollments above the average?
select mascot from school where enrollment > ( select avg ( enrollment ) from school )
but i want above average list only.
select mascot from school where enrollment > ( select avg ( enrollment ) from school )