Creative Code

SELECT COUNT(*) AS USERS FROM USER_INFO WHERE AGE IS NULL;

SELECT ANIMAL_ID, NAME, DATETIME FROM ANIMAL_INS order by NAME ASC, DATETIME DESC;

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;