EasyBasic SELECT

Show customers grouped by country with count

The query

SQL

SELECT
  country,
  COUNT(*) AS customer_count
FROM customers
GROUP BY country
ORDER BY customer_count DESC;

Tested against PostgreSQL 16

Note

“GROUP BY country aggregates all customers per country. Perfect for market analysis.