assignment asks you to implement queries to retrieve data from a simulated Commerce database $($see

document in Email$).$ The Commerce database consists of eight tables: Customers, Categories, Employees,

OrderDetails, Orders, Products, Shippers, and Suppliers. Each table represents a different aspect of the

business. Note that the relationships are already set up$.$ You can start with the queries.

Queries:

$1.$ List all products$$ prices, unit, and names.

Task: Show the product name, unit, and their respective price$$sort from highest to lowest price.

$2.$ Get the details of all products at a price over $$30.$

Task: Retrieve details of all products priced above $$30.$ List the product name along with the

price. Sort again from highest to lowest price.

$3.$ List all customers located in Spain and Germany.

Task: Retrieve a list of customers located in Spain and Germany. Display the customer$$s name,

city, and country$$sort by country $($in any order$).$

$4.$ Find the total number of orders placed by each customer in Spain and Germany.

Task: Determine the total number of orders placed by each customer in Spain and Germany. List

the country followed by the total number of orders $($hint: along with two columns, the query

should result in two rows, one per country$).$

$5.$ Find the total number of products and average product price per supplier.

Task: List the supplier name, the number of products per supplier, and the average price per

supplier.

Copy the SQL query resulting from each task and paste it into a Word document. Make sure each query is

correct. For example:

SELECT CustomerName, City

FROM Customers;

Submit the Access File and the Word document with SQL code via email and labe