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

문제

내가 작성한 오답

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.LENGTH IN (SELECT MAX(LENGTH) FROM FISH_INFO GROUP BY FISH_TYPE)
ORDER BY ID ASC;

내가 작성한 정답

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 I.FISH_TYPE, MAX(I.LENGTH)
	FROM FISH_INFO I
	GROUP BY I.FISH_TYPE)
ORDER BY F.ID ASC;