Revisiting Why SQL’s Order of Execution Matters

A few days ago I thought that the following SQL query would not work— I expected the window function result would be summed multiple times. 🚨 Turns out, I was wrong. This was a great reminder of why understanding SQL’s order of execution is crucial!...