Orders with customer names
Zalora's fulfilment dashboard shows order IDs, but the packing team needs to see whose order they're picking.
From zalora_orders and zalora_customers, return each order's order_id, customer_name, and total_myr. Order the output by order_id.
Schema
▸zalora_customers
| customer_id | INT |
| customer_name | TEXT |
▸zalora_orders
| order_id | INT |
| customer_id | INT |
| total_myr | NUMERIC(10,2) |
Example input
▸zalora_customers
▸zalora_orders
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.