[프로그래머스/MySQL] 있었는데요 없었습니다

 

 

 

나의 풀이

SELECT  INS.ANIMAL_ID,
        INS.NAME
FROM    ANIMAL_INS INS
JOIN    ANIMAL_OUTS OUTS
ON      INS.ANIMAL_ID = OUTS.ANIMAL_ID
WHERE   INS.DATETIME > OUTS.DATETIME
ORDER   BY INS.DATETIME