[SQL]

최종코드:

SELECT YEAR(E.DIFFERENTIATION_DATE) AS YEAR
    , (Y.MAX_SIZE-E.SIZE_OF_COLONY) AS YEAR_DEV
    , E.ID
FROM ECOLI_DATA AS E
    INNER JOIN (
        SELECT YEAR(DIFFERENTIATION_DATE) AS YEAR
            , MAX(SIZE_OF_COLONY) AS MAX_SIZE
        FROM ECOLI_DATA
        GROUP BY YEAR(DIFFERENTIATION_DATE)) AS Y
    ON YEAR(E.DIFFERENTIATION_DATE) = Y.YEAR
ORDER BY YEAR ASC
    , YEAR_DEV ASC;

 

---

서브쿼리를 구하는 방법입니다.