zoo problem | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

zoo problem

insert into animals(name, type, country_id) values ('slim','giraffe',1); select animals.name, animals.type, countries.country from animals,countries where animals.country_id=countries.id order by animals.country_id desc output and excepted output are same but test case is not passing can any one help me with crt answer

2nd Mar 2021, 3:43 PM
Dharshini B
Dharshini B - avatar
2 Answers
+ 1
'S' and 'G' are supposed to be in uppercase. //
6th May 2021, 7:33 PM
Sakshi Sandesh Lad
Sakshi Sandesh Lad - avatar
0
The sort order should be ascending, not descending. Otherwise the query works, although the exercise recommends using INNER JOIN, which I believe is more efficient.
2nd Mar 2021, 5:38 PM
Brian
Brian - avatar