Task: Text to Code
Input (English): Step 1: find the rows in employee table whose salary greater than 5000.
Step 2: find each value of name, name in the results of step 1 ordered descending by number of rows that correspond of each value.
Step 3: only show the first row of the results
Output (English): SELECT name , name FROM employee WHERE salary > 5000 GROUP BY name ORDER BY Count ( * ) Desc LIMIT 1