[프로그래머스 - 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 INTAKE_CONDITION ='Sick'
ORDER BY ANIMAL_ID ASC;