[프로그래머스 SQL] 물고기 종류 별 대어 찾기

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

프로그래머스

SELECT 
    A.ID AS 'ID',
    B.FISH_NAME AS 'FISH_NAME',
    A.LENGTH AS 'LENGTH'
FROM FISH_INFO AS A
LEFT JOIN FISH_NAME_INFO AS B 
ON A.FISH_TYPE = B.FISH_TYPE
WHERE A.FISH_TYPE IN (
    SELECT FISH_TYPE FROM FISH_INFO
    GROUP BY FISH_TYPE
    HAVING LENGTH = MAX(LENGTH)
)
ORDER BY A.ID ASC;