[프로그래머스,SQL,JOIN] #12. 오랜기간보호한 동물

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

 

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 I.DATETIME
limit 3