Medium
Write a SQL Join Query
Construct a SQL query to retrieve customer order data.
📝 Prompt Content
Write a SQL query for two tables: 'Customers' (id, name) and 'Orders' (order_id, customer_id, amount). Retrieve the names of all customers who have placed an order with an amount greater than 500.