Paid orders over a floor
Your task
Given orders with columns order_id, customer, amount, status and placed, return the orders whose status is paid AND whose amount is at least 50. Return only order_id and amount, sorted by order_id ascending.
Examples
big_paid_orders(orders: dataframe) -> dataframeExample 1
Input
big_paid_orders(orders)orders
| order_id | customer | amount | status | placed |
|---|---|---|---|---|
| 1 | ada | 120.5 | paid | 2024-01-05 |
| 2 | bo | 80 | refunded | 2024-01-07 |
| 3 | ada | 45.25 | paid | 2024-02-11 |
| 4 | cy | 200 | paid | 2024-02-14 |
| 5 | bo | 15.75 | pending | 2024-03-02 |
| 6 | ada | 60 | paid | 2024-03-19 |
Output
| order_id | amount |
|---|---|
| 1 | 120.5 |
| 4 | 200 |
| 6 | 60 |