Join Orders with Customers

Write a SQL query to list all orders with customer names.

Expected Columns

• order_id
• customer_name
• amount
• status

Example Output

| order_id | customer_name | amount | status | |----------|---------------|--------|--------| | 1 | Rajesh Kumar | 76500 | Delivered | | 2 | Sunita Devi | 8850 | Delivered | | ... | ... | ... | ... |