EasyWHERE & Filtering

Find products with price between 100 and 500 AND in stock

The query

SQL

SELECT name, price, stock
FROM products
WHERE price BETWEEN 100 AND 500
  AND stock > 0
  AND is_active = TRUE;

Tested against PostgreSQL 16

Note

“Multiple conditions with AND — all must be true. OR requires any one to be true.