este código que a mi parecer está igual al mostrado en el curso me da error
SELECT ENVASE, SABOR,
CASE
WHEN PRECIO_DE_LISTA >=12 THEN "COSTOSO"
WHEN PRECIO_DE_LISTA >=5 AND PRECIO_DE_LISTA < 12 THEN "ASEQUIBLE"
ELSE "BARATO"
END AS PRECIO, MIN(PRECIO_DE_LISTA) AS PRECIO_MINIMO
FROM tabla_de_productos
WHERE TAMANO = "700 ML"
group by ENVASE,
CASE
WHEN PRECIO_DE_LISTA >=12 THEN "COSTOSO"
WHEN PRECIO_DE_LISTA >=5 AND PRECIO_DE_LISTA < 12 THEN "ASEQUIBLE"
ELSE "BARATO"
END
ORDER BY ENVASE;
Error
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jugos_ventas.tabla_de_productos.SABOR' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
