The database contains three tables containing information about this company$$s sales process: Inventory, Sales, and SalesItems. Use the Relationships window to link the tables together.

The SalesItems table records the quantity and price of each item sold on each sale $($sales may include more than one item$).$ Calculate the extended amount of sale $($call it Amt$)$ for each item $($Quantity $*$ UnitPrice$).$ Include InvoiceID, InventoryID, Quantity, and UnitPrice in the query. Name the query Item$\_$Extension$\_$Calculation.

Calculate the total dollar amount of each sale. Include InvoiceID, InvoiceDate, CustomerID, and EmployeeID from the Sales table and the Amt from the Item$\_$Extension$\_$Calculation query. Name the query Sale$\_$Amount$\_$Calculation.

Calculate total sales for each inventory item.

Calculate total sales.

Calculate the month in which each sale occurred. Include InvoiceID and InvoiceDate from the Sales table. Name the query Sales$\_$Months. $($Hint: Look for the Month function in the expression builder.$)$

Calculate the sum of sales for each month.