T-SQL 101: #123 Using Multiple CTEs in a Single T-SQL Query - The Bit Bucket

https://blog.greglow.com/2025/03/02/t-sql-101-123-using-multiple-ctes-in-a-single-tsql-query/