window functions are harder than i thought

nailed the first few interview problems until they stacked two partition by clauses. suddenly realized i was thinking about them completely wrong. now i'm wondering if i actually understand them at all. submitted by /u/Even_Mal [link] <a hr