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

문제

나의 해답

select count(*) as FISH_COUNT 
from FISH_INFO as I join 
     FISH_NAME_INFO as N on I.FISH_TYPE = N.FISH_TYPE
    where FISH_NAME in ('BASS','SNAPPER')

해설

• select count(*) as FISH_COUNT : 조건에 맞는 행의 수를 계산

• from FISH_INFO as I join FISH_NAME_INFO as N on I.FISH_TYPE = N.FISH_TYPE : fish_type를 기준으로 조인

• where FISH_NAME in ('BASS','SNAPPER') : 이름이 bass, snapper인 것만