Task: Text to Code
Input (English): Step 1: find rows in Faculty table whose Sex equals M.
Step 2: find each value of Rank the results of step 1 along with the number of the corresponding rows to each value
Output (English): SELECT Count ( * ) , Rank FROM Faculty WHERE Sex = "M" GROUP BY Rank