Examine the data in the ORD_ITEMS table: Evaluate the following query: Which statement is true regarding the outcome of the above query?

Question

Options

• AIt gives an error because the having clause should be specified after the group by clause.
• BIt gives an error because all the aggregate functions used in the having clause must be specified
• CIt displays the item nos with their average quantity where the average quantity is more than double
• DIt displays the item nos with their average quantity where the average quantity is more than double

• A
  3% (1)
• B
  3% (1)
• C
  84% (31)
• D
  11% (4)

No community discussion yet for this question.