ERROR: GROUP BY position ... is not in select list

Reason:

A GROUP BY clause refers to a non-existent expression in the SELECT clause.

Resolution:

Correct the GROUP BY clause.

Tips:

• The error message indicates the part of the GROUP BY clause which is invalid.