Write SQL and Python, run instantly in your browser, and track your progress.
You are a Regional Growth Analyst at Netflix. The North American team is analyzing subscriber health across the US, Canada, and Australia markets. They need a list of subscribers who are in good standing - either active or past_due (potentially recoverable) accounts from these key markets.
This requires combining multiple conditions: checking if a value is in a list AND matching multiple acceptable statuses.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
You are a Regional Growth Analyst at Netflix. The North American team is analyzing subscriber health across the US, Canada, and Australia markets. They need a list of subscribers who are in good standing - either active or past_due (potentially recoverable) accounts from these key markets.
This requires combining multiple conditions: checking if a value is in a list AND matching multiple acceptable statuses.
| Column Name | Type |
|---|---|
| user_id | int64 |
| object | |
| full_name | object |
| country | 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 |
|---|---|---|---|
| 55 | Amit Nakamura | AU | active |
| 8 | Juan Hernandez | AU | active |
| 17 | Michael Ryan | AU | active |
| 1 | Andrew Brown | CA | active |
| user_id | full_name | country | account_status |
|---|---|---|---|
| 55 | Amit Nakamura | AU | active |
| 8 | Juan Hernandez | AU | active |
| 17 | Michael Ryan | AU | active |
| 1 | Andrew Brown | CA | active |
Showing first 5 of 19 rows.
Showing first 5 of 19 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 |
| 10 | Daniel Rossi | CA | active |
| 10 | Daniel Rossi | CA | active |