In this assignment, you will be writing some database queries based on the ADW data warehouse we have been using in class. You should use Azure Data Studio to explore the database. Remember, it$$s not unusual for database administrators to change the database structure and forget to update the documentation! Check your results carefully.

Problem $1$

You have been asked to understand how successful the Touring$-3000$ promotion was. Produce a report that retrieves the reseller name, country name, product category name, total sales amount, and currency name for this promotion. Be sure to show the highest value sales first.

Problem $2$

You have been asked to examine the performance of sales using the Euro currency. Produce a report showing state or province name, city name, and total reseller sales, subtotaled by city,

for all EURO sales. You should have three columns, called State$/$Province$,$ City, and Total Reseller Sales, in alphabetical order by State$/$Province$.$ The total for each state or province should have the word "Total" instead of NULL in the city column. The overall total should have the word "Grand" in the State$/$Province column.

Problem $3$

Produce a report that illustrates the total amount of reseller sales by currency. Ensure that you

show the greatest value first, and please round to two decimal places.

Problem $4$

Leadership wants to compare the effectiveness of the Touring$-1000$ and Touring$-3000$ promotions across fiscal quarters for reseller sales. Produce a report with the following columns:

FiscalYear, English Promotion Name, Currency Name, FiscalQ$2,$ FiscalQ$3$

N$.$B$.$ The FiscalQ$2$ and FiscalQ$3$ columns should contain the total sales the

given fiscal year and promotion name.

Problem $5$

Leadership wants to improve profitability by targeting geographies with low spend as a function of income. Develop a report that shows sales territory region, associated state province name, currency, average income, average sales, and average sales as a percentage of average income. Order the result set so that the lowest share of income is first.