[Programmers SQL 고득점 Kit] String, Date [3/5] 중성화 여부 파악하기

문제 link
https://programmers.co.kr/learn/courses/30/lessons/59409

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/06_STRING%2CDATE/STRING%2CDATE-3.sql

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
ORDER BY ANIMAL_ID;