SELECT * FROM apartments WHERE price>AvG(price) and status="Not rented".this is apartment project query .plz look what is wrong

Answer 1

SELECT * FROM Apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;

This working😄

Answer 2

Guess it is ignoring the "not rented" statement in the coding.

Answer 3

Select * From Apartments
Where price>=(Select AVG (price) From Apartments)
Order by price;

Answer 4

It’s not working

Answer 5

Tricky. The rented is lower than the AVG. If you can calculate that easy enough and then work out where parenthesis go. This has owned me for a few days. It always makes sense once you see the correct syntax but everything else does until that point too lol

Answer 6

SELECT * FROM Apartments
WHERE price > ( SELECT AVG(price)FROM Apartments) and status in ('Not rented')
ORDER BY price;

Answer 7

Answer:-
select*from apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price

Answer 8

jajajaja This is the code.
SELECT * FROM Apartments
WHERE price > ( SELECT AVG(price)FROM Apartments) and status in ('Not rented')
ORDER BY price;

the first code i had was this and it worked, i was forgetting I could use the FUNCTION AND:
SELECT * FROM Apartments
WHERE price > ( SELECT AVG(price)FROM Apartments)
ORDER BY price;

Answer 9

select * from apartments
where price > ( select avg(price)from apartments) and status !='rented' order by price;

Answer 10

SELECT * FROM Apartments
WHERE price>(select AVG(price) FROM Apartments) and status='Not rented'
Order BY price

Working

Answer 11

Ok thank you 🔥

Answer 12

Apartments
You want to rent an apartment and have the following table named Apartments:

Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price' column.
Recall the AVG keyword.

SELECT id, city, address, price, status
FROM Apartments
WHERE price > ( SELECT AVG(price)FROM Apartments)
ORDER BY price;

GOOD LUCK ....ITS WORKING

Answer 13

What is the code for this ?

Answer 14

SELECT * FROM Apartments WHERE price >= (SELECT AVG(price) FROM Apartments) ORDER BY price;

Answer 15

select * from Apartments where price>(select AVG(price) from Apartments) order by price

This one is working

Answer 16

A solution of this homework

SELECT * FROM Apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;

Answer 17

SELECT * FROM Apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;

Answer 18

SELECT * FROM Apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;

Answer 19

hi

Answer 20

hope this can help you

SELECT * FROM Apartments
WHERE price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;