[String, Date] - 중성화 여부 파악하기

[문제 설명]

[출력 예시]

 

-- mysql
-- case
--    when ... then ...
--    else
-- end as ''

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