Examine the description of the PRODUCT_INFORMATION table: Which query retrieves the number of products with a null list price?

Question

Options

• ASELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;
• BSELECT COUNT (list_price) FROM product_information WHERE list_price IS NULL;
• CSELECT COUNT (list_price) FROM product_information WHERE list_price = NULL;
• DSELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

• A
  10% (2)
• B
  5% (1)
• C
  5% (1)
• D
  81% (17)

No community discussion yet for this question.