+ 1

Zoo problem is sql

I think my query is right but sololearn shows error in from clause missing my query has from clause insert into animals values('slim','Giraffe',1); SELECT animals.name,animals.type,animals.country_id,countries.country,countries.id FROM animals,countries WHERE animals.country_id=countries.id order By animal.country.id ;

8th Aug 2021, 3:48 PM
Ramesh
3 Answers
+ 3
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 ;
8th Aug 2021, 4:50 PM
Simba
Simba - avatar
+ 2
Simba thank you bro
8th Aug 2021, 5:01 PM
Ramesh
0
Hi Ramesh. Were u able to submit the zoo questions with this simba's code because I have used it and several others means it keeps giving me no input it has refused to congratulate me that am done with the problem for days now. Is there anything wrong with the SQL?
10th Feb 2022, 12:03 PM
Margaret OLAWALE
Margaret OLAWALE - avatar