Hola buenas tardes, en mi caso tengo activado por default "ONLY_FULL_GROUP_BY (true)", por lo que me arrojaba el error:
18:51:27 SELECT estado AS Estado, barrio AS Barrio, MAX(limite_de_credito) AS limite, edad FROM tabla_de_clientes WHERE edad >= 20 GROUP BY Estado, Barrio ORDER BY edad Error Code: 1055. Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jugos_ventas.tabla_de_clientes.EDAD' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.000 sec
Lo puede solucionar agregando 'edad' dentro de la clausula GROUP BY
SELECT estado AS Estado, barrio AS Barrio, MAX(limite_de_credito) AS limite,
edad AS Edad FROM tabla_de_clientes
WHERE edad >= 20
GROUP BY Estado, Barrio, edad
ORDER BY edad;
