Postgres error [column must appear in the GROUP BY clause or be used in an aggregate function] when sub query is usedJan 2015 ⋅ programmer-51783 ⋅ se/dba ⋅ #postgresql #aggregate #subquery #group-by