packtpublishing / sql-for-data-analytics-third-edition Goto Github PK

This issue concerns the calculation of deciles in the solution code.

The book presents the following question in activity 5.01:

4. Calculate which decile each date would fall into compared to other days based on their daily 30-day rolling sales amount.

Problem:
Line 68 of the solution code uses the window function NTILE(10) OVER (ORDER BY moving_avg DESC) AS decile to calculate the decile for each value group in the moving_avg column. However, the resulting decile column appears to be identical to what would be obtained using NTILE(10) OVER () AS decile, which omits the ORDER BY clause.