[groue]

I didn't know about windowing function. This page looks like a nice description: https://community.modeanalytics.com/sql/tutorial/sql-window-...

[gigatexal]

yeah that site is really good for a lot of things. Windowing functions help you write less procedural SQL -- I'm a huge fan.