ERROR: column ... must appear in the GROUP BY clause or be used in an aggregate function

Reason:

A query omitted a non-aggregate expression in its GROUP BY clause.

Resolution:

Group by all non-aggregate expressions.

Tips:

• Include all non-aggregate expressions in a GROUP BY clause