sql/SUM, MAX, MIN (1) 썸네일형 리스트형 [프로그래머스] 연도별 대장균 크기의 편차 구하기 (MySQL) 문제링크 WITH MAX_SIZE_TABLE AS( SELECT MAX(SIZE_OF_COLONY) AS MAX_SIZE, YEAR(DIFFERENTIATION_DATE) AS YEAR FROM ECOLI_DATA GROUP BY YEAR(DIFFERENTIATION_DATE) ) SELECT YEAR(E.DIFFERENTIATION_DATE) AS YEAR, (M.MAX_SIZE - E.SIZE_OF_COLONY) AS YEAR_DEV, E.IDFROM ECOLI_DATA AS E LEFT JOIN MAX_SIZE_TABLE AS M ON YEAR(E.DIFFERENTIATION_DATE) = M.YEARORDER BY YEAR, YEAR_DEV 풀이 방법with .. 이전 1 다음