Atom.

SQL Playground: Window Functions - Sun Oct 2920232:03 PM

A self-contained SQL playground to make sense of Postgres window functions. Thanks to the now, kind of legendary, Mitchell’s Advent of Code series.

week_startactive_usersprev
2023-09-25 00:00:0091NULL
2023-10-02 00:00:0031591
2023-10-09 00:00:00350315
2023-10-16 00:00:00249350
2023-10-23 00:00:00375249