Task: Text to Code
Input (English): Step 1: find the number of rows of each value of Rank, Lname in Faculty table.
Step 2: find Fname, Lname of Faculty table ordered descending by the results of step 1.
Step 3: only show the first 3 rows of the results
Output (English): SELECT Fname , Lname FROM Faculty GROUP BY Rank , Lname ORDER BY Count ( * ) Desc LIMIT 3