Write SQL and Python, run instantly in your browser, and track your progress.
You are a Regional Analyst at Netflix. The International Expansion team needs to understand subscriber distribution across countries for market prioritization. Count how many users are in each country.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | object |
You are a Regional Analyst at Netflix. The International Expansion team needs to understand subscriber distribution across countries for market prioritization. Count how many users are in each country.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | object |
| language | object |
| language | object |
| created_at | object |
| created_at | object |
| account_status | object |
| account_status | object |
| user_id | full_name | country | language | created_at | account_status | |
|---|---|---|---|---|---|---|
| 1 | andrewbrown@icloud.com | Andrew Brown | CA | en | 2025-06-14 | active |
| 2 |
| user_id | full_name | country | language | created_at | account_status | |
|---|---|---|---|---|---|---|
| 1 | andrewbrown@icloud.com | Andrew Brown | CA | en | 2025-06-14 | active |
| 2 |
| country | user_count |
|---|---|
| US | 13 |
| CA | 8 |
| FR | 7 |
| GB | 7 |
| IN | 6 |
| country | user_count |
|---|---|
| US | 13 |
| CA | 8 |
| FR | 7 |
| GB | 7 |
| IN | 6 |
Showing first 5 of 13 rows.
Showing first 5 of 13 rows.
1. Grouping:
2. Aggregation:
3. Output:
1. Grouping:
2. Aggregation:
3. Output:
| anthony.dubois@mail.com |
| anthony.dubois@mail.com |
| Anthony Dubois |
| Anthony Dubois |
| US |
| US |
| en |
| en |
| 2024-11-24 |
| 2024-11-24 |
| active |
| active |
| 3 | david92@hotmail.com | David Wagner | ES | es | 2024-11-25 | active |
| 3 | david92@hotmail.com | David Wagner | ES | es | 2024-11-25 | active |
| 4 | valentina_smith@outlook.com | Valentina Smith | DE | de | 2024-12-17 | active |
| 4 | valentina_smith@outlook.com | Valentina Smith | DE | de | 2024-12-17 | active |
| 5 | omar.wilson@yahoo.com | Omar Wilson | FR | fr | 2025-07-27 | active |
| 5 | omar.wilson@yahoo.com | Omar Wilson | FR | fr | 2025-07-27 | active |