Help please

Question

1) A new animal has come in, with the following details:
name - "Slim", type - "Giraffe", country_id - 1
Add him to the Animals table.
2) You want to make a complete list of the animals for the zoo’s visitors. Write a query to output a new table with each animal's name, type and country fields, sorted by countries.

Answer 1

Can you write or link the tables details?

Answer 2

https://www.chegg.com/homework-help/questions-and-answers/x-zoo-problem-manage-zoo-animal-zoo-comes-different-country-tables-animals-name-type-count-q78504915

Answer 3

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

SELECT name, type, country FROM Animals INNER JOIN Countries ON country_id = Countries.id ORDER BY countri;

Answer 4

Thanks