View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
Which SQL statement would retrieve from the table the number of products having LIST_PRICE
as NULL?
A.
SELECT COUNT(list_price)
FROM product_information
WHERE list_price IS NULL;
B.
SELECT COUNT(list_price)
FROM product_information
WHERE list_price = NULL;
C.
SELECT COUNT(NVL(list_price, 0))
FROM product_information
WHERE list_price IS NULL;
D.
SELECT COUNT(DISTINCT list_price)
FROM product_information
WHERE list_price IS NULL;