intermediate
Generate a Complex SQL Query
Construct an SQL query to join multiple tables.
📝 Contenu du Prompt
Write a SQL query to retrieve the names of all customers who have made a purchase in the last 30 days. Join the 'customers' table with the 'orders' table on 'customer_id'. Order the results by the purchase date in descending order.