Find the average and total capacity of dorms for the students with gender X.
CREATE TABLE dorm (
    student_capacity INTEGER,
    gender VARCHAR
)
SELECT AVG(student_capacity), SUM(student_capacity) FROM dorm WHERE gender = 'X'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the average and total capacity of dorms for the students with gender X. ### Input: CREATE TABLE dorm (
    student_capacity INTEGER,
    gender VARCHAR
) ### Response: SELECT AVG(student_capacity), SUM(student_capacity) FROM dorm WHERE gender = 'X'