Hard
Write a Complex SQL Query
Construct a SQL query to join three tables and filter specific data.
📝 프롬프트 내용
Write a SQL query that retrieves the customer name, order date, and total amount from three tables: Customers, Orders, and OrderDetails. Join them on their respective IDs and filter the results to show only orders placed in the last 30 days with a total amount greater than $100.