오랜 기간 보호한 동물(1)

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

SELECT I.NAME, I.DATETIME
FROM ANIMAL_INS AS I LEFT JOIN ANIMAL_OUTS AS O
ON I.ANIMAL_ID = O.ANIMAL_ID
WHERE O.ANIMAL_ID IS NULL
ORDER BY I.DATETIME ASC LIMIT 3;

 

 

아직 입양 못간 동물을 알기 위해서
입양간 테이블에는 있는데, 입양 보낸 테이블에는 없는 이름
보호서에서 가장 오래있었음 날짜가 가장 작음 - DATE로 날짜가 가장 작은 수 부터 커지는 오름차순 ASC