[MySQL/PGS] Lv.3 : 물고기 종류 별 대어 찾기

 

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

프로그래머스

---

프로그래머스 레벨 3

group by, max 등을 응용하는 문제

 

나의 풀이

SELECT f.ID, fn.FISH_NAME, f.LENGTH 
FROM FISH_INFO f
INNER JOIN FISH_NAME_INFO fn
ON f.FISH_TYPE = fn.FISH_TYPE
WHERE (f.FISH_TYPE, f.LENGTH) IN (SELECT FISH_TYPE, MAX(LENGTH)
		FROM FISH_INFO
		GROUP BY FISH_TYPE)
ORDER BY 1;