IBM
C2090-619 · Question #6
Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;
The correct answer is B. OVER. See the full explanation below for the reasoning.
Question
Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;
Options
- ASUM
- BOVER
- CFROM
- DAVG (SUM(dollars))
How the community answered
(27 responses)- A11% (3)
- B81% (22)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.