as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
create a database query to list the top ten customers based on sales amount
user
select customer_id, sum(sales_amount) 
from customer_transactions 
group by customer_id 
order by sum(sales_amount) desc 
limit 10;
assistant