Answer Happy

View the Exhibit and examine the structure of thePRODUCT 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);