| prov:value
| - If the expression is an aggregate is of the form AVG(C0) OVER(PARTITION BY C1, C2, . . . , Ck), replace it with an expression of the form SUM(SUM(C0) OVER(PARTITION BY C1, C2, . . . , Ck)) OVER( )/SUM(COUNT(C0) OVER(PARTITION BY C1, C2, . . . , Ck)) OVER( ) and move the standard (nested) aggregates into the inner select list. 5.
|