[SQL 문제 풀이] 물고기 종류 별 잡은 수 구하기

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