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

What is the average and total capacity for all dorms who are of 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'