What is wrong with my query??

Question

Solo learn doesn't accept it
/* name - "Slim", type - "Giraffe", country_id - 1 */
INSERT into Animals
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

Answer 1

Fateme Imani
Query is right
1 - there should be semicolon (;) after insert query
2 - SQL doesn't support double quotes so there should be single quotes for a string value

Answer 2

// try this:
insert into Animals (name, type, country_id)
values ('Slim', 'Giraffe', 1);

Answer 3

try this too 👇👇👇
INSERT INTO ANIMALS
VALUES ('Slim', 'Giraffe', 1);
SELECT name, type, country
FROM ANIMALS INNER JOIN COUNTRIES
ON ANIMALS.country_id = COUNTRIES.id
ORDER BY country_id DESC

Answer 4

Yes