[SUM, MAX, MIN/LEVEL2] 연도별 대장균 크기의 편차 구하기 (MySQL)

MySQL

SELECT YEAR(DIFFERENTIATION_DATE) AS YEAR
    , MAX_SIZE_OF_COLONY - SIZE_OF_COLONY AS YEAR_DEV
    , ID
FROM ECOLI_DATA A, ( SELECT   YEAR(DIFFERENTIATION_DATE) AS YEAR
                            , MAX(SIZE_OF_COLONY) AS MAX_SIZE_OF_COLONY
                            FROM ECOLI_DATA
                            GROUP BY YEAR(DIFFERENTIATION_DATE) ) B
WHERE YEAR(DIFFERENTIATION_DATE) = B.YEAR
ORDER BY YEAR(DIFFERENTIATION_DATE), YEAR_DEV