물고기 종류 별 대어 찾기

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

프로그래머스

 

- 나의 코드

select a.ID, b.FISH_NAME, c.LENGTH
from FISH_INFO a, FISH_NAME_INFO b, 
    (select FISH_TYPE, MAX(LENGTH) as LENGTH
    from FISH_INFO
    group by FISH_TYPE) c
where a.FISH_TYPE = b.FISH_TYPE
and a.FISH_TYPE = c.FISH_TYPE
and a.LENGTH = c.LENGTH
order by a.ID;

select a.ID, b.FISH_NAME, a.LENGTH
from FISH_INFO a join FISH_NAME_INFO b
on a.FISH_TYPE = b.FISH_TYPE
where a.LENGTH in (
    select max(LENGTH)
    from FISH_INFO
    where FISH_TYPE = a.FISH_TYPE
)
order by 1;