Please find the names of the dorms that do not have any amenities?
select dorm_name from dorm where dormid not in ( select dormid from has_amenity )
Which dorm has the highest student capacity?
select dorm_name from dorm order by student_capacity desc limit 1
What about the lowest student capacity?
select dorm_name from dorm order by student_capacity asc limit 1
What is the average student capacity of all dorms?
select avg ( student_capacity ) from dorm
What is the dorm ID of the dorm with the lowest student capacity?
select dormid from dorm order by student_capacity asc limit 1