ZOO - not sure what I am doing wrong…?

Question

/* name - "Slim", type - "Giraffe", country_id - 1 */
CREATE VIEW list AS
SELECT name,type, country_id
FROM animals;
INSERT INTO animals(name,type,country_id)
VALUES ('Slim', 'Giraffe',1);
SELECT country_id, countries.id
FROM countries INNER JOIN animals
ON country_id = countries.id;
SELECT name,type,country_id AS country FROM animals;

Answer 1

Thank you friend so much!

Answer 2

Hi Tevin,
May I suggest you to search the forum first? this query had been uploaded many times so I'm sure you can get some clues from earlier discussions.

Search by 'zoo' term 👍