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
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