Examine the data in the ORD_ITEMS table: Evaluate this query: Which statement is true regarding the result?

Question

Options

• AIt returns an error because the HAVING clause should be specified after the GROUP BY clause.
• BIt returns an error because all the aggregate functions used in the HAVING clause must be
• CIt displays the item nos with their average quantity where the average quantity is more than
• DIt displays the item nos with their average quantity where the average quantity is more than

• A
  14% (3)
• B
  5% (1)
• C
  73% (16)
• D
  9% (2)

No community discussion yet for this question.