SQL查询每天，每月的平均值

这样的一张数据表

按每天显示AQI的平均值

 SELECT  DATE_FORMAT(CREATE_DATE,'%Y/%m/%d') AS `date`,
 AVG(AQI) AS `AVG`
 FROM `T_STHJJ_MSOP_AQI`
 GROUP BY `date` LIMIT 30

查询结果为：

SELECT YEAR(CREATE_DATE) AS `year`,MONTH(CREATE_DATE) AS `month`,DAY(CREATE_DATE) AS `day`,
 AVG(AQI) AS `AVG`
 FROM `T_STHJJ_MSOP_AQI`
 GROUP BY `year`,`month`,`day` LIMIT 30

查询结果为：

每月平均值：

SELECT YEAR(CREATE_DATE) AS `year`,MONTH(CREATE_DATE) AS `month`,
 AVG(AQI) AS `AVG`
 FROM `T_STHJJ_MSOP_AQI`
 GROUP BY `year`,`month`

查询结果为：