PostgreSQL window functions make it possible to calculate rankings, running totals and rolling averages while keeping every individual row visible instead of collapsing data like a traditional GROUP ...