[프로그래머스] 보호소에서 중성화한 동물

문제

https://school.programmers.co.kr/learn/courses/30/lessons/59045

프로그래머스

 

코드

MySQL

SELECT
    ANIMAL_INS.ANIMAL_ID,
    ANIMAL_INS.ANIMAL_TYPE,
    ANIMAL_INS.NAME
FROM
    ANIMAL_INS
    LEFT JOIN ANIMAL_OUTS
    ON ANIMAL_INS.ANIMAL_ID = ANIMAL_OUTS.ANIMAL_ID
WHERE
    ANIMAL_OUTS.DATETIME IS NOT NULL
    AND ANIMAL_INS.SEX_UPON_INTAKE LIKE 'Intact%'
    AND (ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Spayed%'
        OR ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Neutered%')
ORDER BY
    ANIMAL_ID