SELECT ANIMAL_ID,NAME,'O' as 중성화
from ANIMAL_INS
where SEX_UPON_INTAKE like '%Neutered%'
or SEX_UPON_INTAKE like '%Spayed%'
union
SELECT ANIMAL_ID,NAME,'X' as 중성화
from ANIMAL_INS
where SEX_UPON_INTAKE not like '%Neutered%'
and SEX_UPON_INTAKE not like '%Spayed%'
order by ANIMAL_ID
not like
특정 문자열을 포함하지 않는가
union
쿼리의 결과 합치기