The orders table contains order amounts.
Return order_id, amount for orders with an amount from 50 to 150 inclusive. Sort by order_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
orders7 rows| order_id (int) | amount (double) |
|---|---|
| 1 | 49.99 |
| 2 | 50 |
| 3 | 75 |
| 4 | 150 |
| 5 | 150.01 |
| 6 | 120 |
| 7 | 20 |
Column names and order must match. Sort order is specified in the question.