SQL Solution to Combine Two Months of Demand Data into a Single Row with Aggregated Columns

Handling Multiple Lags in SQL with Window Functions: A Dynamic Approach