A dataset contains employee information with columns for EmployeeID, LastName, Department, and Salary. You need to present a report showing the top $5$ employees in alphabetical name order with the highest salaries across all departments. Which of the following sorting approaches will achieve this result efficiently?

Multiple Choice

Sort the data by "Salary" $($descending$)$ and then by "LastName" $($ascending$)$ and select the top $5$ rows.

Sort the data by "Department" and then by "Salary" $($descending$)$ and select the top $5$ rows.

Group the data by "Department" and sort each group by "Salary" $($descending$).$ Then, manually identify the top earners across departments.

Create a calculated field that adds "Department" and "Salary" and sort by this new field $($ascending$).$ Select the top $5$ rows.