user
Create a SQL query to get the list of customers who purchased items over $500.

Additional Context:
Given two tables: Orders and Customers.

Answer:
assistant
SELECT * FROM Customers WHERE id IN (SELECT customer_id FROM Orders WHERE amount > 500)