（119）Examine the data in the ORD_ITEMS table:

ORD_NO ITEM_NO QTY

Evaluate the following query:

SELECT item_no, AVG(qty) FROM ord_items

HAVING AVG(qty) > MIN(qty) * 2

GROUP BY item_no;

Which statement is true regarding the outcome of the above query?

A. It gives an error because the HAVING clause should be specified after the GROUP BY clause.

B. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.

C. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

D. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

答案：（C）

解析：

A（X），Having子句可以放在Group By子句之前。

ITPub博客

OCP 1Z0-051-119

最新文章