SQL Fundamental. Anyone help me please. I have tried to run this code, but the code that I created incorrect (not error)

Question

INSERT INTO Animals VALUES ('Slim', 'Giraffe', 1);
SELECT Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id=Countries.id ORDER BY country ASC ;

Answer 1

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 2

Ramnivas Yadav

Answer 3

try adding Countries.country instead of just country after ORDER BY..

Answer 4

Thank you, I also have tried that and the result is stil incorrect

Answer 5

don't worry, it's a bug.... i tried doing other module projects nothing is running....
no input no output...

Answer 6

yes, that's happened to my code, this is not an error but it can't be executed. I'm curious