（148）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 products

GROUP BY prod_category

HAVING avg(prod_list_price) < ALL (SELECT max(prod_list_price)/2 FROM products GROUP BY prod_category);

B.

SELECT prod_category, avg(prod_list_price)

FROM products

GROUP BY prod_category

HAVING avg(prod_list_price) > ANY (SELECT max(prod_list_price)/2 FROM products GROUP BY prod_category);

C.

SELECT prod_category, avg(prod_list_price)

FROM products

HAVING avg(prod_list_price) < ALL (SELECT max(prod_list_price)/2 FROM products GROUP BY prod_category);

D.

SELECT prod_category, avg(prod_list_price)

FROM products

GROUP BY prod_category

HAVING avg(prod_list_price) > ANY (SELECT max(prod_list_price)/2 FROM products);

答案：（A）

ITPub博客

OCP 1Z0 051 148

最新文章