보호소에서 중성화한 동물

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

SELECT INS.ANIMAL_ID, INS.ANIMAL_TYPE,INS.NAME 
FROM ANIMAL_INS AS INS JOIN ANIMAL_OUTS AS OUTS ON INS.ANIMAL_ID = OUTS.ANIMAL_ID 
WHERE INS.SEX_UPON_INTAKE LIKE 'Intact%' AND OUTS.SEX_UPON_OUTCOME IN ('Neutered Male', 'Spayed Female') 
ORDER BY INS.ANIMAL_ID

 

 

---