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
Find the number of amenities for each of the dorms that can accommodate more than 100 students.
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
select count ( * ) , t1 . dormid from dorm as t1 join has_amenity as t2 on t1 . dormid = t2 . dormid where t1 . student_capacity > value group by t1 . dormid
Find the number of amenities for each of the dorms that can accommodate more than 100 students .