Counting Customers by Country
Easy
5
77.8% Acceptance
Objective: Determine the number of customers from each country.
Tables Used:
Customer
Instructions:
- Write an SQL query to count the number of customers from each country. You should use the
Customer
table for this. - The result should contain two columns:
Country
: Name of the country.CustomerCount
: Total number of customers from that country. Name your column exactly asCustomerCount
.
- Ensure your results are ordered by
Country
in ascending order.
Expected Output Columns:
Country
CustomerCount