[프로그래머스 - ORACLE] 어린 동물 찾기

---

CREATE 문

CREATE TABLE ANIMAL_INS (
ANIMAL_ID			VARCHAR2(100)	NOT NULL
ANIMAL_TYPE			VARCHAR2(100)	NOT NULL
DATETIME			TIMESTAMP 	    NOT NULL
INTAKE_CONDITION		VARCHAR2(100)	NOT NULL
NAME				VARCHAR2(100)	NULL
SEX_UPON_INTAKE			VARCHAR2(100)	NOT NULL
);

 

---

• 내 풀이

SELECT
    ANIMAL_ID,
    NAME
FROM ANIMAL_INS 
WHERE NOT INTAKE_CONDITION = 'Aged'
ORDER BY ANIMAL_ID ASC;