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 product_jnformation
GROUP BY product_status);