특정 물고기를 잡은 총 수 구하기

1. 문제 

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

프로그래머스

 

 

2.풀이

select count(*) as FISH_COUNT

from FISH_INFO 

where 
 FISH_TYPE in (
    select FISH_TYPE
    from FISH_NAME_INFO
    where FISH_NAME in ('BASS','SNAPPER') )

 

 

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 IN ('BASS', 'SNAPPER')

 

join으로 합쳐서 조건 걸어도 되고 조건을 서브쿼리로 걸어도 다 정답처리나오네용