[GROUP BY/LEVEL2] 특정 조건을 만족하는 물고기별 수와 최대 길이 구하기 (MySQL)

MySQL

SELECT    COUNT(*) AS FISH_COUNT
        , MAX(IFNULL(LENGTH, 10)) AS MAX_LENGTH
        , FISH_TYPE
FROM FISH_INFO
GROUP BY FISH_TYPE
HAVING AVG(IFNULL(LENGTH, 10)) >= 33
ORDER BY FISH_TYPE