CREATE TABLE dorm (student_capacity NUMBER, gender VARCHAR2)

Find the average and total capacity of dorms for the students with gender X.
SELECT AVG(student_capacity), SUM(student_capacity) FROM dorm WHERE gender = 'X'
SELECT AVG("student_capacity"), SUM("student_capacity") FROM "dorm" WHERE "gender" = 'X'