How to aggregate for first values in group...

How to query a chat list with number of unread messages...

Aggregate columns with additional (distinct) filters...

SQL (standard) join count by several columns...

Getting an [null] response from SQL query using json_agg...

Returning aggregates over CASE expressions from a function...

Get conditional count and conditional DISTINCT count in a single SELECT...

Mapping array to composite type to a different row type...

Conditional SQL count...

Conditional aggregate queries...

Conditional count of rows where at least one peer qualifies...

Postgres COUNT number of column values with INNER JOIN...

Combine two queries to count distinct strings with different filters...

How to find the average of a subset of values from a table in PostgreSQL?...

Count devices per day in a given date range...

Compute a running ratio of two totals...

Counting the number of repeating customer and new customer for every month in sql...

Aggregate the same column in multiple different ways...

Pivot table without crosstab/tablefunc...

SQL: Organizing summed data into two columns...

Calculate the sum of a field filtered by a window defined on another field...

PostgreSQL - Left Join with Bad Count Output...

Rails Query - Group By with 2 groups...

Subquery to get aggregate with different WHERE clause...

Select multiple row values into single row with multi-table clauses...

Sum of values from 3rd previous month...

Subquery with the same WHERE clause as query...