연도별 대장균 크기의 편차 구하기(Programmers)

얼떨결에? (gpt가) 맞춘 답 쿼리입니다.
ㅋㅋㅋㅋ

SELECT YEAR(DIFFERENTIATION_DATE) AS YEAR
     , ABS(MAX(SIZE_OF_COLONY) OVER (PARTITION BY YEAR(DIFFERENTIATION_DATE)) - SIZE_OF_COLONY) AS YEAR_DEV
    , ID
FROM ECOLI_DATA
ORDER BY YEAR, YEAR_DEV

GROUP BY 쉽지않네..????
윈도우 함수가 살렸습니다