0

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

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

11th Feb 2021, 6:17 PM
Grigor Hovakimian
Grigor Hovakimian - avatar
6 odpowiedzi
+ 3
Which programming language? Is it sql?
11th Feb 2021, 6:23 PM
Սոֆի
+ 2
for apartment SELECT * FROM Apartments WHERE price > 750 AND status = 'Not rented'ORDER BY price;
12th Feb 2021, 8:47 AM
VṢtēphen
VṢtēphen - avatar
+ 1
Sql, the task with Apartments
11th Feb 2021, 7:44 PM
Grigor Hovakimian
Grigor Hovakimian - avatar
+ 1
I found the solution, from this discussions, though the code i wrote there as an answer was really correct, but it did not work
11th Feb 2021, 7:45 PM
Grigor Hovakimian
Grigor Hovakimian - avatar
+ 1
Now i have encountered a similar problem with the last task "Zoo"
11th Feb 2021, 7:46 PM
Grigor Hovakimian
Grigor Hovakimian - avatar
0
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;
11th Feb 2021, 7:50 PM
Grigor Hovakimian
Grigor Hovakimian - avatar