Finding Young Animals (with.MySQL)

This is an article about finding young animals (with.MySQL).

I want to solve the coding test problem, find out how to solve it differently from the retrospective of the problem I solved, and get to know.

Let’s get to the problem first.

Problem

Please write a SQL statement that looks up the ID and name of the young animal 1 among the animals that came into the animal shelter.

At this time, please check the results in the order of ID.

Problem Description

The ANIMAL_INS table is a table that contains information about animals that have entered the animal shelter.

ANIMAL_INS table structures are as follows: ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE indicate the animal’s ID, species, start date of protection, status, name, gender, and neutralization at the start of protection, respectively.

ANIMAL_INS table

problem solving

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION != "Aged"
ORDER BY ANIMAL_ID;

Solution Description

The ID and name of young animals were searched in the ANIMAL_INS table required in the problem, and the results were searched in order of ID.