쿼테1 [프로그래머스 SQL] 물고기 종류별 대어 찾기 문제 풀이 코드WITH FISH_LENGTH_MAX AS ( SELECT MAX(LENGTH) AS MAX_LENGTH, FISH_TYPE FROM FISH_INFO GROUP BY FISH_TYPE)SELECT I.ID, N.FISH_NAME, M.MAX_LENGTH AS LENGTHFROM FISH_LENGTH_MAX M JOIN FISH_INFO I ON M.FISH_TYPE = I.FISH_TYPE AND M.MAX_LENGTH = I.LENGTHJOIN FISH_NAME_INFO N ON M.FISH_TYPE = N.FISH_TYPEORDER BY 1 ASC ;문제 - Level 3물고기 종류별로 가장 큰 물고기의 ID,.. 2024. 9. 27. 이전 1 다음
