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(DISTINCT list_price) FROM product_information WHERE list_price IS
NULL;
B.
SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;
C.
SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
D.
SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS
NULL;