what's Smith Hall student capacity?
select distinct ( 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 where t1.dorm_name = "Smith Hall"
sorry meant least number of amenities
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's the name of the dorm with the highest amenities?
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 ( * ) desc limit 1
which of this dorm has student capacity of 355?
select dorm_name from dorm where student_capacity = 355