보호소에서 중성화한 동물

SELECT A.ANIMAL_ID,
A.ANIMAL_TYPE,
A.NAME
FROM ANIMAL_INS A JOIN ANIMAL_OUTS B
ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE 
(A.SEX_UPON_INTAKE NOT LIKE '%Spayed%'
AND A.SEX_UPON_INTAKE NOT LIKE '%Neutered%')
AND 
(B.SEX_UPON_OUTCOME LIKE '%Spayed%'
OR B.SEX_UPON_OUTCOME LIKE '%Neutered%')
ORDER BY A.ANIMAL_ID;