For each dorm, how many amenities does it have?
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