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



Leave a Reply 1

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