[Oracle] 프로그래머스 SQL 고득점 Kit - JOIN

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

코딩테스트 연습 - 없어진 기록 찾기

SELECT ANIMAL_ID, NAME
FROM ANIMAL_OUTS
WHERE ANIMAL_ID NOT IN (SELECT ANIMAL_ID FROM ANIMAL_INS)
ORDER BY ANIMAL_ID;

---

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

코딩테스트 연습 - 있었는데요 없었습니다

SELECT I.ANIMAL_ID, I.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;

---

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

코딩테스트 연습 - 오랜 기간 보호한 동물(1)

SELECT T.NAME, T.DATETIME
FROM (
    SELECT I.NAME, I.DATETIME, RANK() OVER (ORDER BY I.DATETIME) DATERANK
    FROM ANIMAL_INS I LEFT JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
    WHERE I.ANIMAL_ID NOT IN (SELECT ANIMAL_ID FROM ANIMAL_OUTS)
) T
WHERE T.DATERANK <= 3
ORDER BY T.DATETIME;

---

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

코딩테스트 연습 - 보호소에서 중성화한 동물

SELECT I.ANIMAL_ID, I.ANIMAL_TYPE, I.NAME
FROM ANIMAL_INS I LEFT JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
WHERE SEX_UPON_INTAKE NOT LIKE SEX_UPON_OUTCOME
ORDER BY ANIMAL_ID;