CODE EXAMPLE FOR SQL

postgresql must appear in the group by clause or be used in an aggregate function

Try using "DISTINCT" instead of "GROUP BY"