[Level 2] 중성화 여부 파악하기

[문제]

 

 

 

[코드]

SELECT ANIMAL_ID
    , NAME
    , CASE 
        WHEN SEX_UPON_INTAKE LIKE '%Neutered%' 
            OR SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O' 
        ELSE 'X'
        END AS 중성화
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;