What is the average enrollment size?
select avg(enrollment) from university
Which schools have basketball team?
select school from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id
Please list the enrollment of these schools.
select school, enrollment from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id
Which of them have enrollments that are smaller than the average enrollment size?
select school from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where enrollment < (select avg(enrollment) from university)
Please list their team names.
select t2.team_name from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where enrollment < (select avg(enrollment) from university)