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

---

CREATE 문

CREATE TABLE ANIMAL_INS (
ANIMAL_ID				VARCHAR(50)	NOT NULL PRIMARY KEY,
ANIMAL_TYPE				VARCHAR(50)	NOT NULL,
DATETIME				TIMESTAMP	NOT NULL,
INTAKE_CONDITION			VARCHAR(50)	NOT NULL,
NAME					VARCHAR(50)	NULL,
SEX_UPON_INTAKE				VARCHAR(50)	NOT NULL
);



CREATE TABLE ANIMAL_OUTS (
ANIMAL_ID				VARCHAR(50)	NOT NULL,
ANIMAL_TYPE				VARCHAR(50)	NOT NULL,
DATETIME				TIMESTAMP	NOT NULL,
NAME					VARCHAR(50)	NULL,
SEX_UPON_OUTCOME			VARCHAR(50)	NOT NULL,
CONSTRAINT FK_ANIMAL_ID FOREIGN KEY(ANIMAL_ID) REFERENCES ANIMAL_INS(ANIMAL_ID)
);

 

---

• 내 풀이

SELECT
    I.ANIMAL_ID,
    I.ANIMAL_TYPE,
    I.NAME
FROM ANIMAL_INS I JOIN ANIMAL_OUTS O
ON I.ANIMAL_ID = O.ANIMAL_ID
AND I.SEX_UPON_INTAKE LIKE ('Intact%')
AND O.SEX_UPON_OUTCOME NOT LIKE ('Intact%')