OCP-1Z0-051 第116题 GROUP BY,HAVING子句应用

一、原题

Examine the data in the ORD_ITEMS table:
ORD_NO     ITEM_NO        QTY
1            111           10
1            222           20
1            333           30
2            333           30
2            444           40
3            111           40
You want to find out if there is any item in the table for which the average maximum quantity is more than 50.
You issue the following query:
SQL> SELECT AVG(MAX(qty))
              FROM ord_items
      GROUP BY item_no
           HAVING AVG(MAX(qty))>50;
Which statement is true regarding the outcome of this query?
A. It executes successfully and gives the correct output.
B. It gives an error because the HAVING clause is not valid.
C.