SELECT rasp.experiment3g.ID,avg(rasp.experiment3g.Temp_Air_C),avg(rasp.experiment3g.Temp_Ground_C),avg(rasp.experiment3g.Humidity_Percent),avg(rasp.experiment3g.Preasure_mmHg),CAST(rasp.experiment3g.DATE_MEAUSREMENT AS DATE) FROM rasp.experiment3g WHERE DATE_MEAUSREMENT BETWEEN SUBDATE(CURDATE(), INTERVAL 1 YEAR) AND NOW() GROUP BY CAST(rasp.experiment3g.DATE_MEAUSREMENT AS DATE) ORDER BY CAST(rasp.experiment3g.DATE_MEAUSREMENT AS DATE);