Source
SQL Compilation Error (GROUP BY) - Code compatibility with MySQL
ISSUE: Some customers might face a compilation error due to columns that are not used in any aggregations or listed in the group by columns.