Show the total enrollment of campus with id 1 in each year.
select totalenrollment_ay from enrollments where campus = 1
What is the average of these numbers?
select avg(totalenrollment_ay) from enrollments where campus = 1
What campuses had more than 400 total enrollment in year 1956?
select t1.campus from campuses as t1 join enrollments as t2 on t1.id = t2.campus where t2.year = 1956 and totalenrollment_ay > 400
Among them, which campuses have more than 200 full time enrollment?
select t1.campus from campuses as t1 join enrollments as t2 on t1.id = t2.campus where t2.year = 1956 and totalenrollment_ay > 400 and fte_ay > 200