Problem
A. Find a list of all products along with their vendor names and contacts.
B. Find vendor name and contact who supplied '2.5-in.wd. screw, 50'.
C. List all products (productcode, product description) supplied by Gomez Bros.
D. List the Vendorname and theirtotal inventory from highest inventoryto lowest inventory.
E. Write a query that summarizes the value of products currently in inventory. Note that the value of each product is a result of multiplying the units currently in inventory by the unit price. Sort the results in descending order by subtotal.
F. Find the total value of the product inventory.
G. List all products orderedby Kathy Smith.