Question

e. Display the RegionID, RegionName, and number of stores in the region for all regions. f. For each product category, display the CategoryID, CategoryName, and average price of a product in the category.

Answer 1

a)

SELECT * FROM VENDOR;

b)

SELECT ProductID, ProductName, ProductPrice FROM PRODUCT WHERE ProductPrice >=100;

c)

SELECT ProductID, ProductName, ProductPrice, VendorName FROM PRODUCT INNER JOIN VENDOR ON PRODUCT.VendorID=VENDOR.VendorID ORDER BY ProductID;

d)

SELECT ProductID, ProductName, ProductPrice FROM PRODUCT INNER JOIN CATEGORY ON PRODUCT.CategoryID=CATEGORY.CategoryID WHERE CATEGORY.CategoryName='Camping' ;