[프로그래머스_SQL] 물고기 종류 별 잡은 수 구하기

📜문제

---

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

📜정답

---

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

📜노트

---

GROUP BY

FISH_NAME_INFO에서 물고기의 종류 별로 조회하기 때문에 GROUP BY 사용

ORDER BY

물고기를 잡은 수 기준 내림차순으로 정렬을 해야하기 때문에 ORDER BY 사용