Database: dorm_1
Question: What is the average and total capacity for all dorms who are of gender X?
SQL:
SELECT avg(student_capacity) ,  sum(student_capacity) FROM dorm WHERE gender  =  'X'