[Programmers] 015 - 보호소에서 중성화한 동물

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