+ 4

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;

24th Sep 2021, 5:23 AM
😍😀🙏
😍😀🙏 - avatar
7 odpowiedzi
+ 8
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;
24th Sep 2021, 5:30 AM
ÃKR
ÃKR - avatar
+ 6
Amansisa Tadese order by countries.country , i think here the problem was
24th Sep 2021, 5:37 AM
ÃKR
ÃKR - avatar
+ 2
ÃKR thanks bro🙏🙏🙏
24th Sep 2021, 5:31 AM
😍😀🙏
😍😀🙏 - avatar
+ 2
ÃKR ok I got it thanks bro
24th Sep 2021, 5:39 AM
😍😀🙏
😍😀🙏 - avatar
+ 1
ÃKR but bro what was the problem is it a case sensitive I mean in the name of the table???
24th Sep 2021, 5:32 AM
😍😀🙏
😍😀🙏 - avatar
+ 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;
25th Sep 2021, 6:55 PM
Sugandha Das
+ 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
2nd Oct 2021, 7:30 AM
Amit Gupta
Amit Gupta - avatar