SQL last task about Zoo - what do they want from me?

Question

I made:

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

But they say there are no inputs and outputs !? What is wrong?

Answer 1

You are not supposed to create a view, but to select animals and join them with the countries table. So, the insert looks okay. The second statement should just be a select.

Answer 2

Well, it's not perfect. But I do take out a lot using this app and think it is fair that I pay them a little for their work making this app possible. If more paid maybe they would have more resources to fix some issues. But I don't really know how they are setup... But I do feel that there is a lot of anger and unhappiness in the world today. More, it seems, than there was earlier. People seemed to be more tolerant. I try not to get drawn into this aggressive environment.

Answer 3

Relaaaax 😄

Answer 4

Delete view and code will work
Look at mine:

/* name - "Slim", type - "Giraffe", country_id - 1 */
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

There aren’t any views.

Answer 5

I am sorry, but the task is written by some slow person. Cause from it's description it is not clear that VIEW is not needed
"You want to make a complete list of the animals for the zoo’s visitors."
A COMPLETE LIST!!! Idiots

Answer 6

I can't... the thing that they can't do simple task - write clear description is driving me nuts! and this is not the first time I meet this problem! And this all in the light that they are teaching us, and take money for that!