How do I filter rows where unit price is above 20 in SQL?
SELECT * FROM data
WHERE unit_price > 20
ORDER BY unit_price DESC;
Run this query in QueryLocal →
A numeric `WHERE` filter works the same way on any column: `unit_price > 20` keeps rows above the threshold. Combined with `ORDER BY unit_price DESC`, the most expensive matching rows appear first.
A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).