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

 

나의 풀이

SELECT          OUTS.ANIMAL_ID,
                OUTS.NAME
FROM            ANIMAL_OUTS OUTS
LEFT OUTER JOIN ANIMAL_INS INS
ON              OUTS.ANIMAL_ID = INS.ANIMAL_ID
WHERE           INS.ANIMAL_ID is NULL
ORDER           BY OUTS.ANIMAL_ID