물고기 종류 별 대어 찾기(Programmers)

답 쿼리입니다.

WITH T AS (
SELECT FI.FISH_TYPE
     , MAX(LENGTH)
FROM FISH_INFO FI 
     JOIN FISH_NAME_INFO FNI ON FI.FISH_TYPE = FNI.FISH_TYPE 
GROUP BY FI.FISH_TYPE 
)

SELECT ID
     , FNI.FISH_NAME
     , LENGTH
FROM FISH_INFO FI 
     JOIN FISH_NAME_INFO FNI ON FI.FISH_TYPE = FNI.FISH_TYPE 
WHERE (FI.FISH_TYPE , LENGTH) IN (SELECT * FROM T)

이거 맞나요? 똑같은 조인 두번하기 권법 ..? ㅋㅋ