BETWEEN operator for a range of values?

Question

PostgreSQL

Good day to all.

The question is about the BETWEEN operator (or an alternative)
The task is to find the price close_price in the percentage range of prices open_price
Here is the table:


For obvious reasons, the query does not work:

SELECT * FROM table
WHERE close_price BETWEEN 
(select ((open_price * 0.10) + open_price) from table)
AND
(select (open_price - (open_price * 0.10)) from table);

Who can suggest an alternative way?

Answer 1

close_price between open_price * 0.9 and open_price * 1.1

do you mean a simple math operation?