Hi there. Could someone help me with SQL ZOO task please.

Question

My query don't accept, I don't understand why:(

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.id
ORDER BY Countries.country DESC;

Answer 1

https://www.sololearn.com/post/935054/?ref=app
https://www.sololearn.com/discuss/2695161/?ref=app
https://www.sololearn.com/discuss/2695421/?ref=app
https://www.sololearn.com/discuss/2695423/?ref=app
https://www.sololearn.com/discuss/2695443/?ref=app

Answer 2

/*Try this out */

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.id
ORDER BY Countries.country ASC;

/* I did that and collected 100XP */