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

| 문제

https://school.programmers.co.kr/learn/courses/30/lessons/59043

프로그래머스

 

| 풀이

SELECT I.ANIMAL_ID AS ANIMAL_ID, I.NAME AS NAME
FROM ANIMAL_INS I JOIN ANIMAL_OUTS O
ON I.ANIMAL_ID = O.ANIMAL_ID
WHERE I.DATETIME > O.DATETIME
ORDER BY I.DATETIME;