Medium
SQL Query Construction
Generate a SQL query for specific data retrieval.
📝 Prompt Content
Write a SQL query to select the top 10 customers by total purchase amount from a table named 'sales'. Assume the table has columns 'customer_id', 'purchase_amount', and 'transaction_date'.