Task: Text to Code
Input (English): find the average student_capacity and the minimum student_capacity in Dorm table whose gender equals X
Output (English): SELECT Avg ( student_capacity ) , Min ( student_capacity ) FROM Dorm WHERE gender = "X"