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

프로그래머스

 

전체코드

-- 코드를 작성해주세요
WITH CNT AS(
SELECT COUNT(B.FISH_NAME) AS FISH_CNT
FROM FISH_INFO A LEFT JOIN FISH_NAME_INFO B ON A.FISH_TYPE = B.FISH_TYPE
WHERE FISH_NAME = "BASS" OR FISH_NAME = "SNAPPER"
GROUP BY B.FISH_NAME)

SELECT SUM(FISH_CNT) AS FISH_COUNT
FROM CNT;