[My_SQL] 연도 별 평균 미세먼지 농도 조회하기
문제 YEAR 메소드로 년도 부분만 이용하고 AVG와 ROUND 함수를 통해 오염도의 평균치를 구한다.코드SELECT YEAR(ap.ym) as 'YEAR', ROUND(AVG(ap.pm_val1), 2) as 'PM10', ROUND(AVG(ap.pm_val2), 2) as 'PM2.5' FROM AIR_POLLUTION ap WHERE ap.location2 = '수원' GROUP BY YEARORDER BY 1 asc; OR SELECT YEAR(ap.ym) as 'YEAR', ROUND(AVG(ap.pm_val1), 2) as 'PM10', ROUND(AVG(ap.pm_val2), 2) as 'PM2.5'FROM AIR_POLLUTION apGROUP BY YEAR, ap.location1, ap..
더보기