I have tried to execute query for project 3 in sql course but not getting it write

Question

getting it wrong near select statement

Answer 1

CHANDRAKANT
(1) You missed a semicolon on line 3 before SELECT, to indicate a second statement.

(2) countries.country, not animals.country_id based on the problem because the output is sorted by the word and not by their id.

(3) ascending, not descending based on the problem. and the output.

- - - - - - - - - - - - - - -
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
countries.country;

Answer 2

Can you show us your attempt so we may know what needs to be adjusted? thanks.

Answer 3

hi chandrakant, have you solve the question? im also stuck there. is it any limitation set for checking the result? there is no output comeout

Answer 4

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 5

plz help me I am just one step away from getting my certificate

Answer 6

U need to use Inner join, please refer to that section of the course and reattempt the test

Answer 7

i have tried even that also using inner join still didnt get

Answer 8

NURLIYANA i have the same pb

Answer 9

Currently, there are problems with SQL challenges.

https://www.sololearn.com/Discuss/2695208/why-is-it-showing-no-output
https://www.sololearn.com/Discuss/2695161/no-output-error
https://www.sololearn.com/Discuss/2694959/zoo-project

Answer 10

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;

my sql but didn't get result what am i missing