programmers

[프로그래머스] 오랜기간 보호한 동물(1)

대장형아 2023. 10. 22. 19:49
SELECT NAME, DATETIME
FROM ANIMAL_INS
WHERE ANIMAL_ID NOT IN (SELECT ANIMAL_ID FROM ANIMAL_OUTS)
ORDER BY DATETIME
LIMIT 3;