MySQL Error 3029 – ER_AGGREGATE_ORDER_NON_AGG_QUERY

MySQL Error Message

Expression #%u of ORDER BY contains aggregate function
and applies to the result of a non-aggregated query