Which two queries would work?

View the Exhibit and examine the structure of the PRODUCT INFORMATION table. Which
two queries would work? (Choose two.)

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:



Leave a Reply 0

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