[ORACLE] 중성화 수술_ 프로그래머스_LV3

SELECT ANIMAL_ID,NAME ,
CASE 
WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O'
WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
ELSE 'X'
END AS 중성화 from ANIMAL_INS order by ANIMAL_ID;