Intermediate
Create SQL Join Query
Generate a SQL query to join two tables and filter data.
📝 Prompt Content
Write a SQL query that selects the customer name and order amount from two tables, 'Customers' and 'Orders'. Join the tables on 'customer_id'. Filter the results to only show orders where the amount is greater than 500 dollars.