Creative Code

SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL order by ANIMAL_ID;

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERe INTAKE_CONDITION != 'Aged' order by ANIMAL_ID;

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS order by ANIMAL_ID;

SELECT NAME FROM (SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME) WHERE ROWNUM =1;

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION = 'Sick' order by ANIMAL_ID;

-- 코드를 입력하세요 SELECT NAME, DATETIME from ANIMAL_INS order by ANIMAL_ID DESC;