Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator?

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;
A . SUM
B . OVER
C . FROM
D . AVG(SUM(dollars))

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments