[SELECT] 특정 물고기를 잡은 총 수 구하기 (MySQL)

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

프로그래머스

 

- 문제 : 

FISH_INFO 테이블에서 잡은 BASS와 SNAPPER의 수를 출력하는 SQL 문을 작성해주세요. 컬럼명은 'FISH_COUNT`로 해주세요.

 

- 풀이 :

-- FISH_INFO : ID, FISH_TYPE, LENGTH, TIME
-- FISH_NAME_INFO : FISH_TYPE, FISH_NAME

select count(i.ID) FISH_COUNT
from FISH_INFO i
join FISH_NAME_INFO n on i.FISH_TYPE = n.FISH_TYPE
where FISH_NAME = 'BASS'
    or FISH_NAME = 'SNAPPER';