intermediate
Build SQL Query
Construct a complex SQL query based on a description of requirements.
📝 Prompt Content
Act as a SQL expert. Write a query to select the top 5 customers by total purchase amount in the last month from the 'orders' and 'customers' tables. Assume the tables are linked by 'customer_id'.