[프로그래머스, 59409] 중성화 여부 파악하기 (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/59409

프로그래머스

728x90

---

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