JOIN>없어진 기록 찾기

-- 코드를 입력하세요
SELECT **DISTINCT**(B.ANIMAL_ID), B.NAME
FROM ANIMAL_INS A
**JOIN ANIMAL_OUTS B**
**WHERE B.ANIMAL_ID NOT IN (SELECT ANIMAL_ID FROM ANIMAL_INS)**
ORDER BY ANIMAL_ID;