find the names of dorms that can accommodate more than 100 students.
select dorm_name from dorm where student_capacity > 100
what is the average capacity of these dorms?
select avg(student_capacity) from dorm where student_capacity > 100
Find the number of amenities for each of these dorms.
select count(*), t1.dormid from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid where t1.student_capacity > 100 group by t1.dormid