🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 136:

Find the distribution of clients by country

MySQL
Find the customers distribution by countries. For each county get customers count and percent of overal customers.
Output table with columns country, customers_count and percent_of_overall sorted by country name.
Expected result Columns: 3 · Rows: 108
country customers_count percent_of_overall

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query