SQL 고득점 Kit - String, Date Level2 - 중성화 여부 파악하기 - mysql

https://school.programmers.co.kr/learn/challenges?page=1&languages=mysql&order=recent

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

case문

select 
	case 
		when ~ then ~ 
        else ~
    end