Help! why it doesn't work? SQL, "Zoo""quiz.

Question

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

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

Answer 1

Ling
INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY country ;

Answer 2

Thanks Wedad Saleh, I put ; in front of Order by country, so it doesn't work. Now it works. Thanks again. And thanks John Robotane too.

Answer 3

prefix name, type, and country with the tables they belong to:

SELECT Animals.name, Animals.type, Countries.country FROM
...

Answer 4

Thanks. with or without Animals. name, it works. I use Order by country, but error. I try again.