I am having this problem in one of the project (zoo) in sql, my output and expected output are same but

Question

It's not showing correct solution, I am stuck please help

Answer 1

18oo096_Uttam Kumar

INSERT INTO ANIMALS
VALUES ('Slim', 'Giraffe', 1);

SELECT name, type, country
FROM ANIMALS INNER JOIN COUNTRIES
ON ANIMALS.country_id = COUNTRIES.id

ORDER BY country_id DESC

don't worry about character casing

Answer 2

Thankyou got it

Answer 3

18oo096_Uttam Kumar
what problem, show us your code??

Answer 4

18oo096_Uttam Kumar
you need to select name, type, country and use the inner join on animal country id = countries id,

after that order by country id in descending order

Answer 5

INSERT INTO ANIMALS
VALUES ('SLIM', 'GIRRAFE', '1');
SELECT NAME, TYPE, COUNTRY
FROM ANIMALS INNER JOIN COUNTRIES
On COUNTRY_ID= ID
ORDER BY COUNTRY;

Answer 6

This is the code