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

■ 문제 URL

물고기 종류 별 잡은 수 구하기

■ 문제 풀이

WITH join_tb AS (
    SELECT fi.ID, fi.FISH_TYPE, fn.FISH_NAME
    FROM
        FISH_INFO AS fi
    LEFT JOIN
        FISH_NAME_INFO AS fn
    ON fi.FISH_TYPE = fn.FISH_TYPE
)
SELECT
    COUNT(ID) AS FISH_COUNT,
    FISH_NAME
FROM join_tb
GROUP BY FISH_NAME
ORDER BY FISH_COUNT DESC
;