Zoo Project!

Question

I have been working on this project and I fail to get it right. Can I get some help please?

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

SELECT Animals.name, Animals.type, Countries.country
FROM Animals INNER JOIN Countries
ON Animals.country_id = Countries.country
ORDER BY Countries.country;

Answer 1

Abit Jurkuch Not sure but I think this challenge have problems right now as I also tried to run my old correct solution and it just showed "No output".

Answer 2

Abit Jurkuch

Problem is with SQL Compiler. My solved problems are also not working.

Answer 3

Abit Jurkuch

There should be ORDER BY country_id DESC

Answer 4

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

Answer 5

Copy this code and like and check please thank you

Answer 6

still that doesn't work

Answer 7

thanks!

Answer 8

what about Apartments problem

Answer 9

Me too I have the same problem!