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

문제

MYSQL

내가 작성한 정답

select count(*) FISH_COUNT
from fish_info i 
join fish_name_info n on i.fish_type = n.fish_type and n.fish_name in ('BASS','SNAPPER');

이전에 작성한 정답

SELECT COUNT(*) FISH_COUNT
FROM FISH_INFO F
LEFT JOIN FISH_NAME_INFO N ON F.FISH_TYPE = N.FISH_TYPE
WHERE N.FISH_NAME IN ('BASS','SNAPPER');