A teddy bear Western Bulldogs Australian Rules Football fan sitting on an Essendon Bombers beanie — by the end of the article we will judge how these two AFL teams’ seasons are going (photo: author)

Smoothing Data In SQL

Implement A Moving Average to Smooth Your Data in SQL

A problem found throughout the world of data is how to distinguish signal from noise. When dealing with data that comes in a sequence, such as time series data (the most familiar example but by no means the only example), a frequent method of dealing with the problem is to apply a smoother.