[SUM, MAX, MIN/LEVEL3] 물고기 종류 별 대어 찾기 (MySQL)

MySQL

SELECT   A.ID
        , B.FISH_NAME
        , A.LENGTH
FROM FISH_INFO A, FISH_NAME_INFO B
WHERE A.FISH_TYPE = B.FISH_TYPE
AND( A.FISH_TYPE, A.LENGTH )  IN (SELECT FISH_TYPE, MAX(LENGTH)
                                    FROM FISH_INFO
                                    GROUP BY FISH_TYPE )