SQL Window Functions Clicked When I Stopped Collapsing Rows

I needed a simple SQL report: every order, with the customer's total spending in the next column. My...