List order_id and status for all orders, sorted by status in this business order: pending, delivered, returned, cancelled, then by order_id.
25 rows with columns order_id, status — first 3 shown:
| # | ||
|---|---|---|
| 1 | 1017 | pending |
| 2 | 1025 | pending |
| 3 | 1001 | delivered |
Run your code to see the output here.