CREATE TABLE dorm (dormid NUMBER, dorm_name CLOB, student_capacity NUMBER, gender CLOB)
CREATE TABLE lives_in (stuid NUMBER, dormid NUMBER, room_number NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE has_amenity (dormid NUMBER, amenid NUMBER)
CREATE TABLE dorm_amenity (amenid NUMBER, amenity_name CLOB)

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'