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