SELECT ao.ANIMAL_ID, ao.ANIMAL_TYPE, ao.NAME
from ANIMAL_OUTS ao join ANIMAL_INS ai
on ao.ANIMAL_ID = ai.ANIMAL_ID
and ai.SEX_UPON_INTAKE like "Intact%"
and (ao.SEX_UPON_OUTCOME like "Spayed%"
or ao.SEX_UPON_OUTCOME like "Neutered%")
order by ao.ANIMAL_ID