[프로그래머스] 없어진 기록 찾기

---

SELECT T1.ANIMAL_ID
    , T1.NAME
    FROM ANIMAL_OUTS T1
        LEFT JOIN ANIMAL_INS T2
            ON T1.ANIMAL_ID = T2.ANIMAL_ID
                AND T1.ANIMAL_TYPE = T2.ANIMAL_TYPE
    WHERE T2.ANIMAL_ID IS NULL