who did the zoo question on SQL ?

Question

i have been battling the zoo question, my input was finally similar to the output but it's not accepted as been right

Answer 1

can you please post your code here?

Answer 2

Folawiyo Gbadamosi ,

> remove the trailing semicolon on second last line

> order should be done by `country`

Answer 3

INSERT into Animals
VALUES ('Slim', 'Giraffe', 1);
SELECT Animals.name, Animals.type, country
from Animals
INNER JOIN countries
ON Animals.country_id=countries.id;
Order by Animals.country_id