MySql查询最后一天24小时每小时的平均数方法

[qq_16609613]

MySql查询最后一天24小时每小时的平均数方法
select ID,(select DATE_FORMAT(MAX(DATE),'%Y-%m-%d') from monitor) AS d,AVG(TEMP),AVG(HUMI),AVG(ZPH01),
AVG(DSMIC),substring(DATE,12,2) AS sj
from monitor
WHERE
id='GZXC97845043.909203784.1126261780'
group by substring(DATE,12,2)

mysql查询最大日期
select DATE_FORMAT(MAX(DATE),'%Y-%m-%d') from monitor