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);
View the Exhibit and examine the structure of thePRODUCT INFORMATION table.Which two queries would work? (Choose two.)
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am