[GROUP BY/LEVEL2] 물고기 종류 별 잡은 수 구하기 (MySQL)

MySQL

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