코딩테스트 연습 > SELECT > 특정 물고기를 잡은 총 수 구하기
https://school.programmers.co.kr/learn/courses/30/lessons/298518


select count(*) as FISH_COUNT
from FISH_INFO fi join FISH_NAME_INFO fni on fi.fish_type = fni.fish_type
where fni.fish_name in ('BASS','SNAPPER')