Zoo question

Question

I think this Zoo question in SQL don’t have an answer

Can someone help me out?

/* name - "Slim", type - "Giraffe", country_id - 1 */

INSERT INTO Animals
VALUES ("slim", "Giraffe" ,1) ;

SELECT country
FROM countries INNER JOIN Animals
ON countries.ID = Animals.Country_id
ORDER BY country ;

Answer 1

You need to check animal type, animal name and it's country based on the given database

Finally you have have to check it using conditions by comparing given id match the countries id or not and lastly sort it in descending order

INSERT INTO Animals (name, type, country_id)
VALUES ('Slim', 'Giraffe', 1);

SELECT animals.name, animals.type, countries.country FROM animals, countries
WHERE animals.country_id=countries.id order by animals.country_id desc

I hope it clears your doubt

Answer 2

Ejeh Wayne most welcome

Answer 3

Aysha 💕 it sure did clear my doubt

Answer 4

А вопрос где? Тут какие-то отрывки без смысла:
Ни структуры таблиц
Ни чем они заполнены
И вообще, внутреннее соединение подразумевает наличие данных, идентичных, в обеих таблицах.
Предлагая пустую таблицу стран запрос вернет пустую выборку