Schema: CREATE TABLE dorm (student_capacity INTEGER, gender VARCHAR)
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'