SELECT avg(student_capacity) ,  sum(student_capacity) FROM dorm WHERE gender  =  'X'
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 = value
What is the average and total capacity for all dorms who are of gender X ?