How to properly request a request?

Question

SQL

Good afternoon, ladies and gentlemen.
How to display
Display the number of customers from each country?
www.w3schools.com/sql/trysql.asp?filename=trysql_s...
SELECT Country,COUNT(CustomerName)
FROM [Customers]
In this case, I only get one city.

Answer 1

use grouping like:

SELECT Country,COUNT(CustomerName)
FROM [Customers] GROUP BY Country