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

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

프로그래머스

 

[풀이과정]

JOIN, COUNT, USING

 

[코드 1]

SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO A
    JOIN FISH_NAME_INFO B ON A.FISH_TYPE = B.FISH_TYPE
WHERE B.FISH_NAME IN ('BASS', 'SNAPPER');

 

[코드 2]

SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO A
	JOIN FISH_NAME_INFO B USING (FISH_TYPE)
WHERE B.FISH_NAME IN ('BASS', 'SNAPPER');