4 ms·
Since no one has mentioned SQL yet: SELECT * FROM products WHERE (stock > 100 AND price < 5) OR (price BETWEEN 20 AND 35 AND category =
by taffer 7y ago
Since no one has mentioned SQL yet:
SELECT *
FROM products
WHERE
(stock > 100 AND price < 5)
OR (price BETWEEN 20 AND 35 AND category = 'outdoors')
OR name ILIKE '%mountain%';