Database: dorm_1
Question: Find the average and total capacity of dorms for the students with gender X.
SQL:
SELECT avg(student_capacity) ,  sum(student_capacity) FROM dorm WHERE gender  =  'X'