[SQL 문제 풀이] 물고기 종류 별 대어 찾기

SELECT 
    B.ID,
    A.FISH_NAME,
    B.LENGTH
FROM
    FISH_NAME_INFO AS A
        JOIN
    FISH_INFO AS B ON B.FISH_TYPE = A.FISH_TYPE
WHERE
    B.LENGTH = (
        SELECT MAX(B2.LENGTH)
        FROM FISH_INFO AS B2
        WHERE B2.FISH_TYPE = A.FISH_TYPE
    );