I meed help writing a query for requesting a report that includes the following information for all sales reps:

Territory

Sales Rep First and Last Name

Product Description

Number of Items Sold with a total

Sales Amount with a total

We kindly ask that you provide us with this report by May $17,2023$ so that we can review and analyze the data. The report will be used to help us identify any areas for improvement and to ensure that we are meeting our sales targets.

Please include the following features in your report.

Include our company logo$.$

Include a title of the report named Sales by Territory.

The Report Body Should be a table that contains all the information mentioned above in a hierarchical display where Territory is the top node, sales rep is the second node and to remaining items are rows of data within the Tablix.

Report Footer should include page number and total pages of the report.

The report should have the following user input parameters:

a$.$ Sales Rep drop down list

b$.$ Territory drop down list

The report should be exported to Word or Excel for distribution to the other team members.