물고기 종류 별 대어 찾기

https://school.programmers.co.kr/learn/courses/30/lessons/293261

프로그래머스

SELECT
    ID, FISH_NAME, LENGTH
FROM
    FISH_INFO FI
JOIN 
    FISH_NAME_INFO FNI ON FI.FISH_TYPE = FNI.FISH_TYPE
WHERE
    (FNI.FISH_TYPE, LENGTH) IN(
        SELECT FISH_TYPE, MAX(LENGTH) AS LENGTH
        FROM FISH_INFO
        GROUP BY FISH_TYPE
        HAVING LENGTH > 10
)