I don’t understand what is wrong?

Question

SELECT * FROM Apartments
WHERE price >3750
AND status = '%Not Rented%'
ORDER BY price;

Answer 1

1. Why you didn't pay attention to the hint:
"⚠️Remember the AVG keyword".
2. And what is it in SQL: "="?🤔
3. Look carefully what status should be. 😉

Answer 2

Well, if you use the "%" operator, then use it correctly: " status LIKE 'Not%' " 😉