Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

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?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *