SQL Project

Question

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

Answer 1

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;

Answer 2

Giraffe

Answer 3

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

Answer 4

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

Answer 5

Ok, thanks I will do it.

Answer 6

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.

Answer 7

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

Answer 8

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

Answer 9

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;

Answer 10

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