Task: Text to Code
Input (English): SQL: SELECT Count ( * ) , Rank FROM Faculty WHERE Sex = "M" GROUP BY Rank
Feedback: List number of rows for sex equals M and for sex equals F for each rank .
Output (English): SELECT rank ,  sex ,  count(*) FROM Faculty GROUP BY rank ,  sex