https://leapcell.io/blog/optimizing-complex-aggregations-with-sql-window-functions