sql query for Scenario $3$: You are a data analyst for a Manufacturer.

Use the Northwind database, and use the SQL query answer from question $2$ as a starting point.

All of the reported products sold in scenario $2$ belong to a category.

Management wants to know from all of the products reported in scenario $2,$ how much did the customer spend in each product category?

The query will be similar to the previous query, but you will have to make a few adjustments to get category$-$level information.

Report Requirements:

Your report should show the customer$$s name, the category name, and total cost $($unit price $*$ quantity $-$ discount$)$ spent in each product category.

For example, if the customer purchased $3$ products in the 'Confections' category, you will show one row with the customer$$s name, the category name, and a single total cost.

The report should reflect just the products whose product name begins with the letter s or t $($make sure it is case insensitive$).$

The report should also filter just the category totals where the customer spent more than $$500$ in that category.

The report should be sorted by customer name, total cost descending, and category name.

Lastly, the total cost should be rounded to $2$ decimals.