I am trying to solve the next problem, Apartments, but whatever i try as a code, it does not work

Question

I think i am coding right, but still no results, please anyone help me with Apartments tasks, that is the next

Answer 1

Which programming language?
Is it sql?

Answer 2

for apartment

SELECT * FROM Apartments WHERE price > 750 AND status = 'Not rented'ORDER BY price;

Answer 3

Sql, the task with Apartments

Answer 4

I found the solution, from this discussions, though the code i wrote there as an answer was really correct, but it did not work

Answer 5

Now i have encountered a similar problem with the last task "Zoo"

Answer 6

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;