View the Exhibit and examine the structure of the PRODUCTS tables.
You want to generate a report that displays the average list price of product categories where the average list price is less than half the maximum in each category.
Which query would give the correct output?
A. SELECT prod_category,avg(prod_list_price)FROM productsGROUP BY prod_categoryHAVING avg(prod_list_price) < ALL(SELECT max (prod_list_price)/2FROM productsGROUP BY prod_category);
B. SELECT prod_category,avg(prod_list_price)FROM productsGROUP BY prod_categoryHAVING avg(prod_list_price) > ANY(SELECT max (prod_list_price)/2FROM productsGROUP BY prod_category);
C. SELECT prod_category,avg(prod_list_price)FROM productsHAVING avg(prod_list_price) < ALL(SELECT max(prod_list_price)/2FROM productsGROUP BY prod_category);
D. SELECT prod_category,avg(prod_list_price)FROM productsGROUP BY prod_categoryHAVING avg(prod_list_price) > ANY(SELECT max (prod_list_price)/2FROM products);