Write SQL and Python, run instantly in your browser, and track your progress.
You are a Regional Analyst at Netflix. The US Marketing team needs a list of all subscribers based in the United States for a localized promotional campaign. Filter the users DataFrame to find all US-based subscribers.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | object |
You are a Regional Analyst at Netflix. The US Marketing team needs a list of all subscribers based in the United States for a localized promotional campaign. Filter the users DataFrame to find all US-based subscribers.
| 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 |
|---|---|---|---|
| 18 | Andrew Nair | US | canceled |
| 36 | Anil Davis | US | active |
| 2 | Anthony Dubois | US | active |
| 15 | Emily Muller | US | active |
| user_id | full_name | country | account_status |
|---|---|---|---|
| 18 | Andrew Nair | US | canceled |
| 36 | Anil Davis | US | active |
| 2 | Anthony Dubois | US | active |
| 15 | Emily Muller | US | active |
Showing first 5 of 13 rows.
Showing first 5 of 13 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 |
| 39 | Feng Bernard | US | active |
| 39 | Feng Bernard | US | active |