[SQL문제풀기] 물고기 종류 별 대어 찾기

문제

MYSQL

내가 작성한 정답

select f.ID, n.FISH_NAME, f.LENGTH
from fish_info f
join fish_name_info n on f.fish_type = n.fish_type
where (f.fish_type,f.length) in (select fish_type, max(length) len
                                    from fish_info
                                    group by fish_type)
order by 1;