[SQL문제풀기] 중성화 여부 파악하기

문제

MYSQL, ORACLE

내가 작성한 정답

SELECT ANIMAL_ID, NAME,
       CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' OR
                 SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
        ELSE 'X' END "중성화"
FROM ANIMAL_INS
ORDER BY 1;


SELECT ANIMAL_ID, NAME,
       CASE WHEN SEX_UPON_INTAKE NOT LIKE '%Neutered%' AND
                 SEX_UPON_INTAKE NOT LIKE '%Spayed%' THEN 'X'
        ELSE 'O' END "중성화"
FROM ANIMAL_INS
ORDER BY 1;