A database named AdventureWorks contains two tables named Production.Product and Sales.SalesOrderDetail. The tables contain data on the available products and a detailed order history.
The Production.Product table contains the following two columns:
• ProductID
• Name
The Sales.SalesOrderDetail table contains the following three columns:
• SalesOrderlD
• ProductID
• OrderQty
You need to create a query listing all of the products that were never ordered.
Which statements should you execute?
A.
B.
C.
D.