Zoo project

Question

Answer in SQL
INSERT INTO Animals (name, type, country_id)
VALUES ('Slim', 'Giraffe', 1);

SELECT animals.name, animals.type, countries.country
FROM animals, countries
WHERE animals.country_id=countries.id
order by animals.country_id desc

Answer 1

Output depends entirely on the contents of the "countries" table.

Answer 2

Yeah bruh.....

Answer 3

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 animals.country_id DESC

Just needed changing from:

WHERE animals.country_id=countries.id

to:

ON animals.country_id=countries.id