SQL 28 zoo project I got the expected result but it still says that there is a problem | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
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 Réponses
+ 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