[프로그래머스] SUM, MAX, MIN: 연도별 대장균 크기의 편차 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/299310

프로그래머스

제출 코드

SELECT
	E.YEAR AS YEAR,
	M.MAX_SIZE-E.SIZE_OF_COLONY AS YEAR_DEV,
	E.ID AS ID
FROM 
	(SELECT 
	 YEAR(DIFFERENTIATION_DATE) AS YEAR,
 	 ID, 
 	 SIZE_OF_COLONY
 	 FROM ECOLI_DATA) AS E 
JOIN
	(SELECT 
    	YEAR(DIFFERENTIATION_DATE) AS YEAR,
    	MAX(SIZE_OF_COLONY) AS MAX_SIZE
	FROM ECOLI_DATA
	GROUP BY 1 ) AS M
ON E.YEAR = M.YEAR
ORDER BY 1, 2