medium
SQL Query Generator
Generate a SQL query to join two tables and filter specific data.
📝 提示内容
Write a SQL query for a PostgreSQL database. We have two tables: 'Orders' (order_id, customer_id, order_date, total_amount) and 'Customers' (customer_id, name, city). Write a query to list the names of customers who live in 'New York' and have placed an order with a total_amount greater than $100 in the last 30 days.