[Programmers SQL 고득점 Kit] JOIN [4/4] 보호소에서 중성화한 동물

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

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/05_JOIN/JOIN-4.sql

SELECT ANIMAL_ID, ANIMAL_TYPE, NAME
FROM (SELECT INS.ANIMAL_ID, INS.ANIMAL_TYPE, INS.NAME, INS.SEX_UPON_INTAKE, OUTS.SEX_UPON_OUTCOME
      FROM ANIMAL_INS AS INS
      JOIN ANIMAL_OUTS AS OUTS
      ON INS.ANIMAL_ID = OUTS.ANIMAL_ID
      WHERE INS.SEX_UPON_INTAKE LIKE 'Intact%') AS A
WHERE SEX_UPON_OUTCOME LIKE 'Spayed%' OR SEX_UPON_OUTCOME LIKE 'Neutered%'
ORDER BY ANIMAL_ID