Examine the data in the ORD_ITEMS table:
Evaluate this query:
Which statement is true regarding the result?
A. It returns an error because the HAVING clause should be specified after the GROUP BY clause.
B. It returns 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
no, position having is after or before group by
C
Edited Answer is A
C