find the number of amenities in each dorm.
select t1.dormid, count(*) from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid group by t2.dormid
which dorm has the fewest amenities? List its name.
select t1.dorm_name from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid group by t2.dormid order by count(*) limit 1
what is its capacity?
select t1.student_capacity from dorm as t1 join has_amenity as t2 on t1.dormid = t2.dormid join dorm_amenity as t3 on t2.amenid = t3.amenid group by t2.dormid order by count(*) limit 1