https://eitanblumin.com/2022/05/30/the-best-solution-for-sql-server-partitioning-sliding-window/
The Best Solution for SQL Server Partitioning Sliding Window