select avg(data1) as a from temp WHERE YEAR(mdate)= 2018 and MONTH(mdate)=03 and day(mdate)=25 GROUP BY hour(mdate);
6 6 10 9 10 11 10 14 17 18 19 20 23 22 23 20 21 19 18 18 17 13 12 10
select MAX(s.a) from (select avg(data1) as a from temp WHERE YEAR(mdate)= 2018 and MONTH(mdate)=03 and day(mdate)=25 GROUP BY hour(mdate)) s;
23