Please guys help me to solve, the zoo problem sql. Where did i commit mistake? This code bring the same output required.

Question

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

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 countries.country;

Answer 1

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

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

SELECT zoo.name, zoo.type, countries.country FROM Animals as zoo INNER JOIN countries on zoo.country_id = countries.id order by countries.country

Answer 2

Try to to paste exact same copy ?

Answer 3

Thank you dude, you real helped me. Am so thankful.

Answer 4

I don't know why but it didn't work. These athe last SQL exam if you feel like trying there, you would have helped me a lot.