store producer check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC'

Question

Good day, I updated the version of mysql to 8.0 and I get the syntax error.

BEGIN
SELECT DATE_FORMAT(h.time,'%d-%m-%y') AS Fecha, TIME_FORMAT(h.time, '%H:00') AS `hora`, TIME_FORMAT(h.time, '%H %i') AS `min`, 
GROUP_CONCAT(CONCAT(CASE WHEN s.variable = 'oxigeno' THEN h.value END)) AS oxigeno,
GROUP_CONCAT(CONCAT(CASE WHEN s.variable = 'saturacion' THEN h.value END)) AS saturacion,
GROUP_CONCAT(CONCAT(CASE WHEN s.variable = 'temperatura' THEN h.value END)) AS temperatura,
GROUP_CONCAT(CONCAT(CASE WHEN s.variable = 'salinidad' THEN h.value END)) AS salinidad 
FROM historic_sensor h INNER JOIN sensor s ON h.sensor = s.id
WHERE s.tank = id_tank AND DATE(h.time) BETWEEN DATE_SUB(DATE(NOW()), INTERVAL intervale DAY) AND DATE(NOW())  
GROUP BY s.tank, h.time ASC;
END

this is a query