[SQL 문제 풀이] 보호소에서 중성화한 동물

내가 작성한 쿼리

MySQL, Oracle

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