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

문제

MYSQL

내가 작성한 정답

SELECT COUNT(I.ID) FISH_COUNT, N.FISH_NAME 
FROM FISH_INFO I
JOIN FISH_NAME_INFO N ON N.FISH_TYPE = I.FISH_TYPE
GROUP BY N.FISH_NAME
ORDER BY 1 DESC;