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

문제

내가 작성한 정답

SELECT  COUNT(A.ID) FISH_COUNT, B.FISH_NAME
FROM FISH_INFO A
JOIN FISH_NAME_INFO B ON A.FISH_TYPE = B.FISH_TYPE
GROUP BY 2
ORDER BY 1 DESC