[프로그래머스_sql] 특정 물고기를 잡은 총 수 구하기

- 문제

https://school.programmers.co.kr/learn/courses/30/lessons/298518

 

- 해결

-- 코드를 입력하세요
select count(*) as FISH_COUNT
from FISH_INFO a left join FISH_NAME_INFO b on a.FISH_TYPE = b.FISH_TYPE
where b.FISH_NAME = "BASS" 
or b.FISH_NAME = "SNAPPER"

 

- 생각 

join