[SQL] 물고기 종류 별 잡은 수 구하기

반응형

 

 

 

 

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

프로그래머스

 

 

정답 쿼리

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