1
2
3
4
5
6
7
8
9
10
11
12
13
-- 코드를 입력하세요
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 ASC
        ;