[ORACLE] 보호소에서 중성화한 동물_프로그래머스_LV3

SELECT ins.ANIMAL_ID , ins.ANIMAL_TYPE , ins.NAME
FROM ANIMAL_INS ins
left join ANIMAL_OUTS outs
on ins.ANIMAL_ID = outs.ANIMAL_ID 
where ins.SEX_UPON_INTAKE LIKE 'Intact%' 
and (outs.SEX_UPON_OUTCOME LIKE 'Spayed%' or outs.SEX_UPON_OUTCOME LIKE 'Neutered%');