How correct is this request?

Question

SQL

It is necessary to receive applications in a certain interval that correspond to certain statuses. The request runs fine, but I want to know if it's correct to write code like this.

WHERE Datetime BETWEEN '20211105' AND '20211109' 
AND Status = ('Новый') OR Status = ('В работе') OR Status = ('Доработка')

That is, I made a selection by dates and three statuses (New, In progress, Finalization).

Answer 1

Instead of OR OR OR, you can use the IN operand.
And everything after AND must be enclosed in brackets, because now you may return incorrect answers.