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(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;



Leave a Reply 0

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