[Programmers / MySQL] Level 1 IDs of Animals Without a Name (59039)
[Programmers / MySQL] Level 1 IDs of Animals Without a Name (59039)
| Rank | Language Used |
|---|---|
| Level 1 | 🖼️ MySQL |
🔗 IDs of Animals Without a Name
The ANIMAL_INS table holds information about animals that have come into an animal shelter. The ANIMAL_INS table structure is as follows, where ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, and SEX_UPON_INTAKE represent the animal's ID, species, intake date, condition at intake, name, and sex/neuter status, respectively.
| NAME | TYPE | NULLABLE |
|---|---|---|
| ANIMAL_ID | VARCHAR(N) | FALSE |
| ANIMAL_TYPE | VARCHAR(N) | FALSE |
| DATETIME | DATETIME | FALSE |
| INTAKE_CONDITION | VARCHAR(N) | FALSE |
| NAME | VARCHAR(N) | TRUE |
| SEX_UPON_INTAKE | VARCHAR(N) | FALSE |
Write an SQL statement that retrieves the IDs of animals that were admitted to the shelter without a name. The IDs should be sorted in ascending order.
For example, if the ANIMAL_INS table is as follows
| ANIMAL_ID | ANIMAL_TYPE | DATETIME | INTAKE_CONDITION | NAME | SEX_UPON_INTAKE |
|---|---|---|---|---|---|
| A368930 | Dog | 2014-06-08 13:20:00 | Normal | NULL | Spayed Female |
| A524634 | Dog | 2015-01-02 18:54:00 | Normal | *Belle | Intact Female |
| A465637 | Dog | 2017-06-04 08:17:00 | Injured | *Commander | Neutered Male |
The animal that was admitted most recently is Anna, and Anna was admitted at 2013-11-18 17:03:00. So running the SQL statement should produce the following.
| ANIMAL_ID |
|---|
| A368930 |
Query ANIMAL_INS, retrieving records where NAME is null, ordered by ANIMAL_ID. From those records, retrieve only ANIMAL_ID.
SQL
SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL ORDER BY ANIMAL_ID;