Please help me to solve this solution in SQL | Sololearn: Learn to code for FREE!

+5

Please help me to solve this solution in SQL

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;

8 Answers

New Answer

+7

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;

+6

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

+2

ÃKR thanks broπŸ™πŸ™πŸ™

+2

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

+2

ÃKR ok I got it thanks bro

+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.country order by Countries.country;

+1

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

-1