Which two queries would work?

View the Exhibit and examine the structure of the PRODUCT INFORMATION table. 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_jnformation WHERE list_price < ANY(SELECT
AVG(list_price) FROM productjnformation GROUP BY product_status);

Explanation: