For each order_id in order_items, return items (total quantity) and order_value (sum of quantity × unit_price).
25 rows with columns order_id, items, order_value — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 1001 | 5 | 2345 |
| 2 | 1002 | 3 | 2597 |
| 3 | 1003 | 1 | 4999 |
Run your code to see the output here.