You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）

A. Recreate the query and default the layout.
B. Alter the query, default the layout and redo the boiler plates.
C. Query and manually change the layout to save the boiler plate.
D. Alter the query and make no further change.