Write SQL and Python, run instantly in your browser, and track your progress.
You are a Regional Marketing Manager at Netflix. The North American team needs a list of all subscribers from the US and Canada for a regional content promotion. Filter the users DataFrame to find subscribers from these two countries.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | object |
You are a Regional Marketing Manager at Netflix. The North American team needs a list of all subscribers from the US and Canada for a regional content promotion. Filter the users DataFrame to find subscribers from these two countries.
| 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 |
| user_id | full_name | country | account_status |
|---|---|---|---|
| 1 | Andrew Brown | CA | active |
| 20 | Anna Rossi | CA | suspended |
| 10 | Daniel Rossi | CA | active |
| 31 | Feng Clark | CA | active |
| user_id | full_name | country | account_status |
|---|---|---|---|
| 1 | Andrew Brown | CA | active |
| 20 | Anna Rossi | CA | suspended |
| 10 | Daniel Rossi | CA | active |
| 31 | Feng Clark | CA | active |
Showing first 5 of 21 rows.
Showing first 5 of 21 rows.
1. Data Selection:
2. Filtering:
3. Output:
1. Data Selection:
2. Filtering:
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 |
| 13 | Giulia Yamamoto | CA | past_due |
| 13 | Giulia Yamamoto | CA | past_due |