SQL Playground: Window Functions - Sun Oct 29202310:03 AM
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_start | active_users | prev |
---|---|---|
2023-09-25 00:00:00 | 91 | NULL |
2023-10-02 00:00:00 | 315 | 91 |
2023-10-09 00:00:00 | 350 | 315 |
2023-10-16 00:00:00 | 249 | 350 |
2023-10-23 00:00:00 | 375 | 249 |