프로그래머스 SQL : JOIN

프로그래머스 SQL : JOIN

---

없어진 기록 찾기

SELECT O.ANIMAL_ID,O.NAME FROM ANIMAL_OUTS O 
LEFT JOIN ANIMAL_INS I ON O.ANIMAL_ID = I.ANIMAL_ID
WHERE I.ANIMAL_ID IS NULL;

---

있었는데요 없었습니다

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;

---

오랜 기간 보호한 동물

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

---

보호소에서 중성화한 동물

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

---