SQL query using CUME_DIST() function to calculate cumulative distribution of gamer scores by year in a partitioned result set.

This image features a SQL query that selects gamer names, years, and points from the gamers_stats table. It applies the CUME_DIST() window function to calculate the cumulative distribution of points for each gamer, partitioned by the YEAR and ordered by points. The Result Grid shows names, years, points, and the calculated CumeDistValue, offering insight into each player’s relative standing within their respective year’s performance group.

×

Table Of Content