[프로그래머스 SQL 고득점 kit(oracle)] JOIN - 오랜 기간 보호한 동물(1)(level3)

https://programmers.co.kr/learn/courses/30/lessons/59044

프로그래머스

---

SELECT * 
FROM (SELECT I.NAME, I.DATETIME
    FROM ANIMAL_INS I
    LEFT JOIN ANIMAL_OUTS O
    ON I.ANIMAL_ID = O.ANIMAL_ID 
    WHERE O.ANIMAL_ID IS NULL
    ORDER BY DATETIME)
WHERE ROWNUM <= 3;