MySQL Error 3066 – ER_AGGREGATE_IN_ORDER_NOT_SELECT

MySQL Error Message

Expression #%u of ORDER BY clause is not in SELECT list,
contains aggregate function; this is incompatible with %s