Hard
Generate a SQL JOIN Query
Write a SQL query to join two tables and filter results.
📝 Contenu du Prompt
Write a SQL query for a database with two tables: 'Customers' (id, name, city) and 'Orders' (order_id, customer_id, amount, date). The query should list the names of all customers who live in 'New York' and have placed an order with an amount greater than $100 in the last 30 days.