Counting Customers by Country

Easy
5
79.2% Acceptance

Objective: Determine the number of customers from each country.

Tables Used:

  • Customer

Instructions:

  1. Write an SQL query to count the number of customers from each country. You should use the Customer table for this.
  2. The result should contain two columns:
    • Country: Name of the country.
    • CustomerCount: Total number of customers from that country. Name your column exactly as CustomerCount.
  3. Ensure your results are ordered by Country in ascending order.

Expected Output Columns:

  • Country
  • CustomerCount