SQL Project | Sololearn: Learn to code for FREE!

+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

sql

1/15/2022 3:38:27 AM

jawhr

10 Answers

New Answer

+8

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;

+4

Giraffe

+2

Vaibhav Singh Yah I really did solved it. It worked for me. it was only that letter from “Giraffe”.

+1

Try to search the forum with 'sql zoo' search term, you might get some clues, or even solution to the problem 👍

+1

Ok, thanks I will do it.

+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.

+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

+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... 🤠🤠

+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;

0

I can't believe 😳, it's only on a spelling!a letter