EasyWHERE & Filtering

Find products with low stock (less than 5)

The query

SQL

SELECT product_id, name, stock, price
FROM products
WHERE stock < 5 AND stock >= 0
  AND is_active = TRUE
ORDER BY stock ASC;

Tested against PostgreSQL 16

Note

“Low-stock alert query. In production, combine with notifications or reorder workflows.