[SQL 문제 풀이] 특정 물고기를 잡은 총 수 구하기 (298518)

SELECT COUNT(*) AS FISH_COUNT FROM FISH_NAME_INFO AS A 
JOIN FISH_INFO AS B 
ON A.FISH_TYPE = B.FISH_TYPE
WHERE A.FISH_NAME = 'BASS'
OR A.FISH_NAME = 'SNAPPER';