코딩연습이 좋아서/SQL이 좋아서
연도 별 평균 미세먼지 농도 조회하기
zoaseo
2025. 2. 1. 17:49
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
ORDER BY YEAR;