Write SQL and Python, run instantly in your browser, and track your progress.
You are a Customer Insights Analyst at Netflix. The Retention team wants to understand the geographic spread of users across different account statuses. For each account status, count both the total users and the number of unique countries represented.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | object |
You are a Customer Insights Analyst at Netflix. The Retention team wants to understand the geographic spread of users across different account statuses. For each account status, count both the total users and the number of unique countries represented.
| 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 |
| account_status | user_count | unique_countries |
|---|---|---|
| active | 44 | 12 |
| suspended | 7 | 5 |
| canceled | 5 | 5 |
| past_due | 4 | 3 |
| account_status | user_count | unique_countries |
|---|---|---|
| active | 44 | 12 |
| suspended | 7 | 5 |
| canceled | 5 | 5 |
| past_due | 4 | 3 |
4 rows returned.
4 rows returned.
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 |