[프로그래머스 SQL 고득점 kit(oracle)] JOIN - 보호소에서 중성화한 동물(level4)

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

프로그래머스

---

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 SEX_UPON_INTAKE LIKE 'Intact%'
AND SEX_UPON_OUTCOME NOT LIKE 'Intact%'
ORDER BY ANIMAL_ID;