SQL window functions allow you to perform calculations on a set of rows that are
related to the current row, without the need for self-joins or subqueries. They
are used to perform a calculation across a set of table rows that are somehow
related to the current row, in a way similar to aggregate functions.
Want to learn more? Check out this video
https://mycelial.com/#newsletter
/ mycelial
https://github.com/mycelial
/ discord