user
Create a database query to list the top ten customers based on sales amount
assistant

SELECT customer_id, SUM(sales_amount) 
FROM customer_transactions 
GROUP BY customer_id 
ORDER BY SUM(sales_amount) DESC 
LIMIT 10;