MySQL] 프로그래머스 물고기 종류 별

 

작성 코드

 

select t1.ID, t2.FISH_NAME as FISH_NAME, t1.LENGTH
from FISH_INFO t1 inner join
     FISH_NAME_INFO t2 on t1.FISH_TYPE = t2.FISH_TYPE
     where t1.FISH_TYPE IN (select FISH_TYPE
                           from FISH_INFO
                           group by FISH_TYPE
                           having LENGTH = MAX(LENGTH))
     order by t1.ID