Column must appear in the GROUP BY clause: what it means
Adding the column to GROUP BY silences PostgreSQL and changes the question. On the same data, the fixed query drops a customer who spent 590.
11 min read
Blog
On queries, schemas, and what is expected of anyone allowed near a production database.
RSS