https://liuhongbo.medium.com/maximizing-your-sql-queries-with-the-power-of-window-functions-6f1352a58913
