3. (20 Points) Use INNER JOIN to create a query result. In this query result, list each vendors name and the name of each product the vendor has supplied to our company. You should use the Vendors, Product_Vendors, and the Products tables in the database to complete this task.

4. (15 Points) Use subquery and find the detail of the most expensive product in the table of products.

5. (15 Points) Use the orders table and find the total order values per customer. Hint: Use group by clause and an aggregation function.

CUSTOMERS CustomerlD h CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode CustAreaCode CustPhone Number PK+ ORDERS OrderNumber Order Date ShipDate Customer D Employeel Order Total FK FK EMPLOYEES Employeeld w EmpFirstName EmpLastName EmpStreetAddress EmpCity EmpState EmpZip Code EmpAreaCode EmpPhone Number ORDER_DETAILS OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered PRODUCTS Product Number PK Product Name Product Description Retail Price QuantityOnHand CategoryID FK CATEGORIES CategoryID PK CategoryDescription PRODUCT_VENDORS ProductNumber CPK Vendorld CPK Wholesale Price DaysToDeliver # ORDERS_ARCHIVE OrderNumber PK Order Date ShipDate Customer EmployeeID OrderTotal" VENDORS VendorID PK VendName VendStreetAddress VendCity VendStato VendZipCode VendPhone Number VendFaxNumber VendWebPage VendEmailAddress ORDER_DETAILS_ARCHIVE* OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered *Modify version only CUSTOMERS CustomerlD h CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode CustAreaCode CustPhone Number PK+ ORDERS OrderNumber Order Date ShipDate Customer D Employeel Order Total FK FK EMPLOYEES Employeeld w EmpFirstName EmpLastName EmpStreetAddress EmpCity EmpState EmpZip Code EmpAreaCode EmpPhone Number ORDER_DETAILS OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered PRODUCTS Product Number PK Product Name Product Description Retail Price QuantityOnHand CategoryID FK CATEGORIES CategoryID PK CategoryDescription PRODUCT_VENDORS ProductNumber CPK Vendorld CPK Wholesale Price DaysToDeliver # ORDERS_ARCHIVE OrderNumber PK Order Date ShipDate Customer EmployeeID OrderTotal" VENDORS VendorID PK VendName VendStreetAddress VendCity VendStato VendZipCode VendPhone Number VendFaxNumber VendWebPage VendEmailAddress ORDER_DETAILS_ARCHIVE* OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered *Modify version only