중성화 여부 파악하기

SELECT ANIMAL_ID,
        NAME,
        CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O'
            WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
        ELSE 'X' END "중성화"
FROM ANIMAL_INS

SELECT ANIMAL_ID,
        NAME,
        IF (SEX_UPON_INTAKE LIKE '%Neutered%' OR SEX_UPON_INTAKE LIKE '%Spayed%', 'O', 'X') '중성화'
FROM ANIMAL_INS