The products table contains product prices.
Return product_id, product_name, price for products priced between 20 and 100 inclusive. Sort by product_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
products8 rows| product_id (int) | product_name (string) | price (double) |
|---|---|---|
| 1 | Desk | 80 |
| 2 | Lamp | 19.99 |
| 3 | Chair | 100 |
| 4 | Mug | 15 |
| 5 | Shelf | 20 |
| 6 | Monitor | 120 |
| 7 | Cable | 45.5 |
| 8 | Stand | 99.99 |
Column names and order must match. Sort order is specified in the question.