특정 물고기를 잡은 총 수 구하기

결과값
FISH_COUNT
7

SELECT COUNT(I.ID) AS FISH_COUNT
FROM FISH_INFO AS I JOIN FISH_NAME_INFO AS N
ON I.FISH_TYPE = N.FISH_TYPE
WHERE N.FISH_NAME IN ('BASS', 'SNAPPER');