Examine the data in the ORD_ITEMS table: Evaluate the following query: 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.
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.
Can having clause come before group by? B should be the answer
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Xpla
2 years, 5 months agoXpla
2 years, 5 months ago