help

Question

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

Where is the error here please ?

Answer 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;

Answer 2

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

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