Return multiple columns of the same row as JSON array of objects...

Select grouped column values and their counts via query with JOIN and GROUP BY clauses in CodeIgnite...

Select the row with maximum/minimum value in SQLite...

Aggregate columns with additional (distinct) filters...

Best way to count rows by arbitrary time intervals...

MongoDB and Node.js aggregate using $sample isn't returning a document...

Pandas aggregating hours in group by...

SQL: Computing sum of all values *and* a sum of only values matching condition...

Multiple aggregates in a SELECT statement in MySQL...

BigQuery User Defined Aggregation Function?...

Create array for values from list of columns extracted in Postgres...

PostgreSQL: Combine Count and DISTINCT ON...

Count units by active and inactive dates...

PostgreSQL: Select rows until sum-reduction of a single column reaches over a threshold...

How to use Polars Expressions to improve performance in Polars transformation?...

Aggregating rmse and r2 in r...

ValueError: Must produce aggregated value in pandas...

How to sum duplicates SQL/PSQL...

How to query a Postgresql DB for a fraction of rows fulfilling a criterion in a sliding time window?...

How to find the most consecutive weeks...

MongoDB using $regex in group aggregation...

Spark SQL replacement for MySQL's GROUP_CONCAT aggregate function...

How to pivot and sum data from a joined table...

CASE WHEN to calculate tax on a tier based tax system...

Mongoose aggregate $LOOKUP with $match...

Using GROUP BY with FIRST_VALUE and LAST_VALUE...

Firestore Python SDK - count() aggregation...

Spark SQL: apply aggregate functions to a list of columns...

Selecting an average of records grouped by 5 minute periods...

Maintain the current count of buildings in a different table...