Problem with zoo project in sql

Question

Hello! I have a technical problem and can't to solve this task (SQL Zoo project):
https://www.sololearn.com/learning/eom-project/1060/1059

I've tried these:

insert into Animals (name, type, country_id)
values
("Slim", "Giraffe", 1);

select
animals.name,
animals.type,
countries.country
from
animals
inner join Countries
on animals.country_id = countries.id
order by
countries.country;

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

INSERT INTO Animals (name, type, country_id)
VALUES ("Slim", "Giraffe", 1);

SELECT Animals.name, Animals.type, Countries.country
FROM Animals
INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY Countries.country;

insert into Animals
values ('Slim', 'Giraffe', 1);

select name, type, country
from Animals
join Countries
on Animals.country_id = Countries.id
order by country;

And all of them don't work with the mistake: test case 1, no output

Answer 1

Ahsan Tariq
Yes this works perfectly

Answer 2

And upper side code

Answer 3

Sathe Prerana Satish
Yes! When i copy this code, it worked. Thank you!

Answer 4

Ok I'll try if I can

Answer 5

Ahsan Tariq

Most welcome ☺️☺️

Answer 6

From my experience I learned two things, that may help with this task, one is to write it as two separate sets of commands.
First adds animals to the table:

INSERT INTO Animals (name, type, country_id)
VALUES ('Slim', 'Giraffe', '1'); <--remember to use semicolon to end command

Second, do the rest of the task:

SELECT Animals.name, Animals.type, Countries.country
FROM Animals
INNER JOIN Countries
ON animals.country_id = countries.id
ORDER BY country ASC; <--remember to use semicolon to end command

And also to remember to set order to ascending.
I hope it will help.

Answer 7

I have copy paste this exactly but still no answer

Answer 8

No still the same issue

Answer 9

Ok wait

Answer 10

Had you added something in this code

Answer 11

Where are you running this code

Answer 12

At the given problem playground.

Answer 13

On Sololearn or other playground

Answer 14

Sololearn

Answer 15

Is there any way to send screen shot so you can see what's the problem is . ?

Answer 16

Type first letter of all animals name in upoercase

Answer 17

Ooh thank you it really work for me thanks a lot

Answer 18

Ahsan Tariq

Happy coding ☺️

Answer 19

Hi Владимир
with the second pair Animals and Countries needs to be capital. try that and it might work
- also it should be from just Animals not Animals and Countries

like this...
SELECT Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY Countries.country;

Answer 20

Try this.
It will works.

/* name - "Slim", type - "Giraffe", country_id - 1 */
INSERT INTO Animals(name, type,country_id)
VALUES('Slim','Giraffe',1);

SELECT Animals.name, Animals.type, Countries.country
FROM Animals
INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY Countries.country;