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
construct a sql query to determine the total number of customers in each country.
user
select country, count(*) as total_customers 
from customers 
group by country;
assistant