Write SQL and Python, run instantly in your browser, and track your progress.
You are a Business Analyst at Netflix. The Finance team needs to analyze subscriptions that started in Q2 2025 (April through June). Filter the subscriptions DataFrame to find all subscriptions with a start_date between '2025-04-01' and '2025-06-30' inclusive.
| Column Name | Type |
|---|---|
| subscription_id | int64 |
| user_id | int64 |
| plan_id | int64 |
| start_date | object |
You are a Business Analyst at Netflix. The Finance team needs to analyze subscriptions that started in Q2 2025 (April through June). Filter the subscriptions DataFrame to find all subscriptions with a start_date between '2025-04-01' and '2025-06-30' inclusive.
| Column Name | Type |
|---|---|
| subscription_id | int64 |
| user_id | int64 |
| plan_id | int64 |
| start_date | object |
| status | object |
| status | object |
| subscription_id | user_id | plan_id | start_date | status |
|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active |
| 2 | 41 | 11 | 2025-03-15 | canceled |
| subscription_id | user_id | plan_id | start_date | status |
|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active |
| 2 | 41 | 11 | 2025-03-15 | canceled |
| subscription_id | user_id | start_date | status |
|---|---|---|---|
| 22 | 2 | 2025-04-03 | trial |
| 20 | 49 | 2025-04-08 | active |
| 39 | 27 | 2025-04-08 | active |
| 17 | 35 | 2025-04-10 | active |
| subscription_id | user_id | start_date | status |
|---|---|---|---|
| 22 | 2 | 2025-04-03 | trial |
| 20 | 49 | 2025-04-08 | active |
| 39 | 27 | 2025-04-08 | active |
| 17 | 35 | 2025-04-10 | active |
Showing first 5 of 29 rows.
Showing first 5 of 29 rows.
1. Data Selection:
2. Filtering:
3. Output:
1. Data Selection:
2. Filtering:
3. Output:
| 3 |
| 3 |
| 44 |
| 44 |
| 10 |
| 10 |
| 2025-06-28 |
| 2025-06-28 |
| canceled |
| canceled |
| 4 | 2 | 2 | 2025-02-27 | expired |
| 4 | 2 | 2 | 2025-02-27 | expired |
| 5 | 55 | 3 | 2025-07-10 | active |
| 5 | 55 | 3 | 2025-07-10 | active |
| 6 | 13 | 14 | 2025-06-14 | active |
| 6 | 13 | 14 | 2025-06-14 | active |
| 7 | 45 | 1 | 2025-01-25 | paused |
| 7 | 45 | 1 | 2025-01-25 | paused |
| 8 | 52 | 18 | 2025-04-10 | active |
| 8 | 52 | 18 | 2025-04-10 | active |
| 33 | 39 | 2025-04-14 | expired |
| 33 | 39 | 2025-04-14 | expired |