OCP 1Z0-051-119

（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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1165713/，如需转载，请注明出处，否则将追究法律责任。