https://www.realdbamagic.com/oow2016-exploring-advanced-sql-techniques-using-analytic-functions/
OOW2016: Exploring Advanced SQL Techniques Using Analytic Functions (slides)