Hello!  Can you list the dorm names of the various different dorms?
select dorm_name from dorm
Thanks!  Can you show me the average age of the students living in each of these dorms?
select avg ( t1.age ), t3.dorm_name from student as t1 join lives_in as t2 on t1.stuid = t2.stuid join dorm as t3 on t3.dormid = t2.dormid group by t3.dorm_name
Thanks!  Now can you add to that list the student capacity of each of those dormitories?
select avg ( t1.age ), t3.dorm_name, t3.student_capacity from student as t1 join lives_in as t2 on t1.stuid = t2.stuid join dorm as t3 on t3.dormid = t2.dormid group by t3.dorm_name