SQL 28 zoo project I got the expected result but it still says that there is a problem | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

SQL 28 zoo project I got the expected result but it still says that there is a problem

SQL 28 zoo project I wrote the below code and I get the expected result but it still says that there is a problem in my code INSERT into Animals VALUES ('slim', 'Giraffe', 1); CREATE view Ani AS select Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN Countries on Animals.country_id = Countries.id ORDER BY country; SELECT * FROM Ani

22nd Dec 2021, 10:51 PM
Odeyah Abeles
Odeyah Abeles - avatar
2 Answers
+ 2
The SQL looks good, though it is unnecessary to make it into a view. The problem is in the inserted data where 'slim' should be capitalized as 'Slim'.
23rd Dec 2021, 3:00 AM
Brian
Brian - avatar
0
The name of the animal might need to be capitalised Slim
23rd Dec 2021, 12:41 AM
Rik Wittkopp
Rik Wittkopp - avatar