View the Exhibit and examine the structure of the PRODUCT INFORMATION table.
Which two queries would work? (Choose two.)
A. SELECT product_nameFROM product_informationWHERE list_price = (SELECT AVG(list_price)FROM product_information);
B. SELECT product_statusFROM product_informationGROUP BY product_statusWHERE list_price < (SELECT AVG(list_price)FROM product_information);
C. SELECT product_statusFROM product_informationGROUP BY product_statusHAVING 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);
|
Download Printable PDF. VALID exam to help you PASS. |
 |