Filter paid orders
Return order_id and amount for orders whose status is 'paid' and amount is at least 100. Include exactly 100; exclude NULL amounts. Row order does not matter.
Difficulty: beginner
Show hint
Combine the status check and amount comparison with AND.
Tables and sample data
Each test starts with fresh tables. Result rows may be returned in any order. Column names and column order must match.
| order_id (integer) | customer_id (integer) | amount (numeric) | status (text) | region (text) |
|---|---|---|---|---|
| 1 | 1 | 150 | paid | East |
| 2 | 2 | 80 | paid | West |
| 3 | 1 | 200 | pending | East |
| 4 | 3 | 100 | paid | North |
| order_id | amount |
|---|---|
| 1 | 150 |
| 4 | 100 |