SQL Zoo project - please help me

Question

no output comeout from the coding. also has no playground for SQL to test

please help me. im stuck here..i want to add 1 more animal in table Animals, also want to inner join the table with Countries.

/* 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 country;

Answer 1

NURLIYANA AMIRAH

There should be ORDER BY country_id DESC

Answer 2

Try this
Your code will be

/* name - "Slim", type - "Giraffe", country_id - 1 */
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;

Answer 3

help me
i'need zoo coding

Answer 4

Safarudin
What help do you need

Answer 5

sory AJ..i have tried but the result is no output..