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

-- (1)
SELECT T1.ANIMAL_ID
    , T1.ANIMAL_TYPE
    , T1.NAME
    FROM ANIMAL_INS T1
        INNER JOIN ANIMAL_OUTS T2
            ON T1.ANIMAL_ID = T2.ANIMAL_ID
                AND T1.SEX_UPON_INTAKE <> T2.SEX_UPON_OUTCOME

-- (2)
SELECT T1.ANIMAL_ID
    , T1.ANIMAL_TYPE
    , T1.NAME
    FROM ANIMAL_OUTS T1
        INNER JOIN ANIMAL_INS T2
            ON T1.ANIMAL_ID = T2.ANIMAL_ID
            
    WHERE SUBSTRING_INDEX(T2.SEX_UPON_INTAKE, ' ', 1) = 'Intact'
        AND SUBSTRING_INDEX(T1.SEX_UPON_OUTCOME, ' ', 1) IN ('Neutered', 'Spayed')
            
    ORDER BY ANIMAL_ID