Window Functions in PostgreSQL

A must-know for any data practitioner

Photo by Stephen Dawson on Unsplash

Have you ever found yourself writing long SQL queries with many steps or subqueries containing aggregate functions to calculate seemingly simple metrics? Have you ever wondered if you “couldn’t just calculate along the table differently to make things easier”? Then it might be time to have a look at window functions.