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