In MyGuitarShop, SQL query to return the total number of times each product has been ordered. This query lists the product name and number of times it has been ordered. 

1) Orders Database: PK is OrderID; FK is CustomerID; other fields include: OrderDate, ShipAmount, TaxAmount, ShipDate, ShipAddressID, CardType, CardNumber, CardExpires, BillingAddressID 

2) OrderItems Database: PK is ItemID; FK is OrderID and ProductID; other field names: ItemPrice, DiscountAmount, Quantity

3) Products Database: PK is ProductID; FK is CategoryID; other field names: ProductCode, ProductName, Description, ListPrice, DiscountPercent, DateAdded

 

Note: ProductID is not same as OrderID

Answer rating: 100% (QA)

To retrieve the total number of times each product has been ... View the full answer