[Programmers] 293257번 - 물고기 종류 별 잡은 수 구하기 [MySQL]

문제 링크

---

1. 문제 풀이

FISH_TYPE으로 JOIN 후 FISH_NAME으로 그룹핑을 해줬다.

---

2. 쿼리

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

---