Consider a Products table $($ProductID$,$ ProductName, Price$)$ and Sales table $($SaleID$,$ ProductID, Quantity$).$ Find all products that have never been sold.

SELECT ProductName FROM Products WHERE ProductID NOT IN $($SELECT ProductID FROM Sales$)$;

B

SELECT ProductName FROM Products WHERE ProductID IN $($SELECT ProductID FROM Sales WHERE Quantity $=0)$;

C

SELECT ProductName FROM Products P WHERE EXISTS $($SELECT $*$ FROM Sales S WHERE S$.$ProductID $=$ P$.$ProductID$)$;

D

SELECT P$.$ProductName FROM Products P LEFT JOIN Sales S ON P$.$ProductID $=$ S$.$ProductID WHERE S$.$ProductID IS NOT NULL;