Prev Question
Next Question

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.

5a10492ce9f20 - Which two queries would work?

Which two queries would work? (Choose two.)

A.
SELECT product_name
FROM product_information
WHERE list_price = (SELECT AVG(list_price)
FROM product_information);

B.
SELECT product_status
FROM product_information
GROUP BY product_status
WHERE list_price < (SELECT AVG(list_price)
FROM product_information);

C.
SELECT product_status
FROM product_information
GROUP BY product_status
HAVING list_price > (SELECT AVG(list_price)
FROM product_information);

D.
SELECT product_name
FROM product_information
WHERE list_price < ANY(SELECT AVG(list_price)
FROM product_information
GROUP BY product_status);

Prev Question
Next Question

Leave a Reply

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