Help me please with inner join in sql

Question

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

SELECT animals.name, animals.type, animals.countries_id, countries.country
FROM Animals
INNER JOIN Countries ON animals.country_id=countries.id

Answer 1

animals have country_id as column name. But you using it as animal.countries_id

Answer 2

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 3

Thank you very much!!!

Answer 4

Only SELECT name, type, country. Don't include countries_id in the SELECT. Also remember to sort by country.