Orders with customer names
Return the order_id and the customer's name for every order with the status delivered, ordered by order_id.
Input
(none)
Expected output
101 | Asha Verma 102 | Liam Carter 104 | Mei Tanaka 106 | Noah Schmidt 108 | Priya Nair 110 | Carlos Ruiz 112 | Sofia Rossi
Show a hint
JOIN customers c ON c.customer_id = o.customer_id connects each order to its customer.
Show a solution
SQLLoading the editor…
Run the tests to check your solution.