'속성명'+ROUND+AVG SELECT YEAR(YM) AS YEAR, ROUND(AVG(PM_VAL1), 2) AS PM10, ROUND(AVG(PM_VAL2), 2) AS 'PM2.5' FROM AIR_POLLUTION WHERE LOCATION2 = '수원' GROUP BY YEAR(YM) ORDER BY YEAR ASC;
'속성명'
ROUND
AVG
SELECT YEAR(YM) AS YEAR, ROUND(AVG(PM_VAL1), 2) AS PM10, ROUND(AVG(PM_VAL2), 2) AS 'PM2.5' FROM AIR_POLLUTION WHERE LOCATION2 = '수원' GROUP BY YEAR(YM) ORDER BY YEAR ASC;