+ 4

SQL Project

Hello, I'm solving the project (zoo) from SQL course , it's the last project It shows the output, but it showing no input, thus it shows an error. Have any one had this issue or solved the project?! And overcome the course

15th Jan 2022, 3:38 AM
jawhr
10 Answers
+ 11
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;
15th Jan 2022, 10:59 AM
Vaibhav
Vaibhav - avatar
+ 4
Giraffe
15th Jan 2022, 6:27 AM
Simba
Simba - avatar
+ 2
Vaibhav Singh Yah I really did solved it. It worked for me. it was only that letter from “Giraffe”.
15th Jan 2022, 4:47 PM
jawhr
+ 1
Try to search the forum with 'sql zoo' search term, you might get some clues, or even solution to the problem 👍
15th Jan 2022, 3:43 AM
Ipang
+ 1
Ok, thanks I will do it.
15th Jan 2022, 3:53 AM
jawhr
+ 1
Could you please give me a clue or hint on where the issue is ; since you answered me, it will be greate.and I asked, I believe I'm wanting an answer or discussion around the problem.dont get me wrong I'm thankful for your first replay.
15th Jan 2022, 5:34 AM
jawhr
+ 1
Of course, --------------------- INSERT INTO Animals(name,type, country_id)VALUES('Slim','Girraffe',1); SELECT Animals.name As name, Animals.type As type, Countries.country As country FROM Animals INNER JOIN Countries ON Animals.country_id=Countries.id ORDER BY country; -------------------------- That's my code
15th Jan 2022, 6:24 AM
jawhr
+ 1
insert into animals values('Slim','Giraffe',1); select a.name,a.type,c.country FROM animals a INNER JOIN countries c ON a.country_id=c.id ORDER BY country; Run the below code... đŸ€ đŸ€ 
16th Jan 2022, 7:41 AM
Akram Mulani
Akram Mulani - avatar
+ 1
INSERT INTO Animals VALUES ('Slim', 'Giraffe', 1); SELECT Animals.name, Animals.type, Countries.country FROM Animals JOIN Countries ON animals.country_id = Countries.id ORDER BY country;
18th Jan 2022, 4:57 PM
ƻaneta Szustakiewicz
0
I can't believe 😳, it's only on a spelling!a letter
15th Jan 2022, 6:34 AM
jawhr