T-SQL 101: #122 Simplifying Queries with Common Table Expressions (CTEs) in SQL Server T-SQL - The Bit Bucket

https://blog.greglow.com/2025/02/28/t-sql-101-122-simplifying-queries-with-common-table-expressions-ctes-in-sql-server-tsql/