I've tried nearly everything but still can't get this code right, can someone please point out to me what i'm missing. 😤

Question

INSERT INTO Animals (name, type, country_id)
VALUES (name, 'Slim', type, 'Giraffe', country_id, 1);
SELECT * FROM Animals;
SELECT name, type, country
FROM Animals INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY Countries;

Answer 1

you are using the wrong values.
you have three columns in Animals(name, type, country_id)
VALUES should have three values.
since they are predefined you can just write them between " " for string and numbers for int.
VALUES("Slim", "Giraffe", 1)
when you use name, type and country_id inside VALUES( ), they are treated as variables and they don't exist.
you also don't have to use
SELECT * FROM Animals;

Answer 2

I appreciate the clarity in your answer, thank you! 👊