DB2-1060-00-E GROUP BY specified but no column name follows keyword

No column name given after the GROUP keyword.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Resolution:

Check GROUP BY syntax. Specify the appropriate column that is, the column you want to use as a grouping column.

Note: AMB applies column functions (MAX, MIN, SUM, AVG, or COUNT) to any column in the SELECT list that you did not specify as a grouping column.