SQL Analyst · AVG OVER · ROWS
Smoothing a trend over two months — customer collections · training scenario
Smooth a two-month trend from a customer collections data set designed to control the level of detail and discrepancies. You must produce the result, check it on the source data and explain what it allows you to decide in this customer collections.
SQL Essentials
Unlock this exercise and continue the path.
Smoothing a trend over two months — customer collections · training scenario is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge