Programmers <물고기 종류 별 잡은 수 구하기>

SELECT COUNT(*) FISH_COUNT, FISH_NAME FROM FISH_INFO JOIN FISH_NAME_INFO USING(FISH_TYPE) GROUP BY FISH_TYPE, FISH_NAME ORDER BY FISH_COUNT DESC;