새로운 문자로 출력

CASE WHEN NAME LIKE '특정이름' THEN 'O' ELSE 'X' END 

AS 중성화 

SELECT ANIMAL_ID, NAME, 
CASE WHEN SEX_UPON_INTAKE LIKE '%Spayed%' then 'O' else 'X' end as 중성화 
FROM ANIMAL_INS ORDER BY ANIMAL_ID;