SQL 고득점 Kit - JOIN Level4 - 보호소에서 중성화한 동물 - mysql

https://school.programmers.co.kr/learn/challenges?page=1&languages=mysql&order=recent

select animal_id, animal_type, name
from animal_ins
inner join (
    select animal_id as animal_id1, sex_upon_outcome 
    from animal_outs
    where sex_upon_outcome like '%Spayed%' or sex_upon_outcome like '%Neutered%'
) join1 on animal_ins.animal_id = join1.animal_id1
where animal_ins.sex_upon_intake like '%Intact%'
order by animal_id

where <컬럼명> like '%문자열%'