Rolling sum and average query results are possible by combining the aggregate functions SUM()
or AVG()
with the OVER()
clause, making for powerful analytic queries. I recently learned how to compute a rolling average or sum of values by using the Windowing option of the OVER()
clause, applying the concepts to a data set I am familiar with. I wanted to share my learning with any readers who might be interested…
[Keep reading for more SQL database and PHP/Python-centric content >>>]