Please help me to solve this solution in SQL

Question

here is the last solution of sololearn course and I tried it but I can't done it please see my code and fix me

here is what I tryied:

insert into animals values('Slim', 'Giraffe', 1);
select animals.name, animals.type, countries.country
from animals inner join countries
on animals.country_id = countries.country
order by countries;

Answer 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 2

Amansisa Tadese order by countries.country , i think here the problem was

Answer 3

ÃKR thanks bro🙏🙏🙏

Answer 4

ÃKR ok I got it thanks bro

Answer 5

ÃKR but bro what was the problem is it a case sensitive I mean in the name of the table???

Answer 6

insert into Animals
values('Slim', 'Giraffe', 1);
select Animals.name, Animals.type, Countries.country
from Animals inner join Countries
on Animals.country_id = Countries.country
order by Countries.country;

Answer 7

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

SELECT name,
type,country
FROM Animals
INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY id desc