You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order?
Salary is the primary sort and should be from highest to lowest.
Branch office is the primary sort and should be in A to Z order.
Salary is the primary sort and should be from lowest to highest.
Branch office is the primary sort and should be in Z to A order.