Hi,

You need to add all fields to the GROUP BY clause that are not one of the aggregate functions such as MAX, MIN, SUM, CNT, etc.