SELECT avg(student_capacity) ,  sum(student_capacity) FROM dorm WHERE gender  =  'X'
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 = value
Find the average and total capacity of dorms for the students with gender X .