[MySQL][Lv. 2] 중성화 여부 파악하기 ✨

1. 풀이

풀이1

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;

풀이2 [출처]

SELECT
    ANIMAL_ID
    , NAME
    , IF(SEX_UPON_INTAKE LIKE 'Neutered%' 
         OR SEX_UPON_INTAKE LIKE 'Spayed%', 'O', 'X') AS 중성화
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;