Is the SQL zoo challenge broken?

Question

I did the code using inner join like the challenge wants. It did show the output same as mine. But it won't finish the challenge.

Answer 1

It's 'Giraffe'
G should be uppercase in Giraffe

You can add `[solved]` tag in your question like this
https://www.sololearn.com/Discuss/2600772/?ref=app

So, community will understand that your problem is solved :)

Answer 2

share your code to be helped ^^

no code == no help

Answer 3

to answer your question title: no there isn't any (at least 'free', I guess 'pro' too) code coaches broken ;)

Answer 4

Simba thanks bro, I've overlooked that one for over an hour. How to close this discussion?

Answer 5

/* 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 animals.country_id desc;

this is my code in which it outputs the same as the challenge but it's not congratulating or anything and it doesn't show any error. it's just nothing.

Answer 6

i've tried evry scenario possible from the 1 question in the challenge but its not working

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

Answer 7

'animals' must be lowercased (not 'Animals')