문제 출처

코딩테스트 연습 > GROUP BY > 물고기 종류 별 잡은 수 구하기
https://school.programmers.co.kr/learn/courses/30/lessons/293257

문제 설명

접근 방법

FISH_INFO 와 FISH_NAME_INFO를 FISH_TYPE로 JOIN 한 뒤, FISH_NAME_INFO 로 GROUP BY 시킨다.

SELECT COUNT(*) AS FISH_COUNT, FNI.FISH_NAME
FROM FISH_INFO FI JOIN FISH_NAME_INFO FNI ON FI.FISH_TYPE = FNI.FISH_TYPE
GROUP BY FNI.FISH_NAME
ORDER BY FISH_COUNT DESC

알게된 점

문제푼 흔적