중성화 여부 파악하기

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

프로그래머스

 

- 나의 코드

SELECT ANIMAL_ID, NAME, if(SEX_UPON_INTAKE like '%Neutered%' || SEX_UPON_INTAKE like '%Spayed%', 'O', 'X') as '중성화'
from ANIMAL_INS
order by ANIMAL_ID;

SELECT ANIMAL_ID, NAME, case when SEX_UPON_INTAKE like '%Neutered%' || SEX_UPON_INTAKE like '%Spayed%'
    then 'O'
    else 'X'
    end as '중성화'
from ANIMAL_INS
order by ANIMAL_ID;