코딩연습이 좋아서/SQL이 좋아서

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

zoaseo 2025. 2. 4. 17:53

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 = 'BASS' OR B.FISH_NAME = 'SNAPPER';
댓글수0