New posts in Aggregate Functions

Spark SQL replacement for MySQL's GROUP_CONCAT aggregate function

Count max. number of concurrent user sessions per day

Optimizing COUNT(DISTINCT) slowness even with covering indexes

Generate_series in Postgres from start and end date in a table

PostgreSQL - string_agg with limited number of elements

Applying a custom groupby aggregate function to output a binary outcome in pandas python

Using an aggregate function in where

MYSQL CONCAT MAX LENGTH

Create a pivot table with PostgreSQL

GROUP BY + CASE statement