Write SQL and Python, run instantly in your browser, and track your progress.
You are a Revenue Operations Analyst at HubSpot. The finance team needs a current roster of active subscriptions for revenue forecasting and capacity planning.
Your task is to provide a list of subscriptions that are currently active (as of today), including their plan details and auto-renew status. Sort by the most recent start date first.
| Column Name | Type |
|---|---|
| subscription_id | INTEGER |
| org_id | INTEGER |
| plan_id | INTEGER |
You are a Revenue Operations Analyst at HubSpot. The finance team needs a current roster of active subscriptions for revenue forecasting and capacity planning.
Your task is to provide a list of subscriptions that are currently active (as of today), including their plan details and auto-renew status. Sort by the most recent start date first.
| Column Name | Type |
|---|---|
| subscription_id | INTEGER |
| org_id | INTEGER |
| plan_id | INTEGER |
| start_date |
| start_date |
| TEXT |
| TEXT |
| end_date | TEXT |
| end_date | TEXT |
| status | TEXT |
| status | TEXT |
| seats_purchased | INTEGER |
| seats_purchased | INTEGER |
| auto_renew | INTEGER |
| auto_renew | INTEGER |
| payment_method | TEXT |
| payment_method | TEXT |
| discount_percent | INTEGER |
| discount_percent | INTEGER |
| sales_rep | TEXT |
| sales_rep | TEXT |
| created_at | TEXT |
| created_at | TEXT |
| subscription_id | org_id | plan_id | start_date | end_date | status | seats_purchased | auto_renew | payment_method | discount_percent | sales_rep | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4 |
| subscription_id | org_id | plan_id | start_date | end_date | status | seats_purchased | auto_renew | payment_method | discount_percent | sales_rep | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4 |
| subscription_id | org_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 7 | 11 | 2 | 2025-05-28 | trialing | 1 | |
| 27 | 45 | 13 | 2025-05-25 | active |
| subscription_id | org_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 7 | 11 | 2 | 2025-05-28 | trialing | 1 | |
| 27 | 45 | 13 | 2025-05-25 | active |
Showing first 5 of 16 rows. Active subscriptions as of reference date sorted by most recent start date.
Showing first 5 of 16 rows. Active subscriptions as of reference date sorted by most recent start date.
1. Output Columns:
2. Filtering:
3. Ordering:
1. Output Columns:
2. Filtering:
3. Ordering:
| 1 |
| 1 |
| 2025-03-21 |
| 2025-03-21 |
| trialing |
| trialing |
| 906 |
| 906 |
| 1 |
| 1 |
| card |
| card |
| 25 |
| 25 |
| 2025-03-21 |
| 2025-03-21 |
| 2 | 34 | 4 | 2025-04-24 | 2025-07-01 | canceled | 212 | 0 | invoice | 0 | 2025-04-24 |
| 2 | 34 | 4 | 2025-04-24 | 2025-07-01 | canceled | 212 | 0 | invoice | 0 | 2025-04-24 |
| 3 | 7 | 6 | 2025-06-05 | 2025-07-15 | suspended | 2 | 1 | card | 10 | 2025-06-05 |
| 3 | 7 | 6 | 2025-06-05 | 2025-07-15 | suspended | 2 | 1 | card | 10 | 2025-06-05 |
| 4 | 7 | 12 | 2025-01-10 | active | 16 | 1 | card | 15 | Alex Thompson | 2025-01-10 |
| 4 | 7 | 12 | 2025-01-10 | active | 16 | 1 | card | 15 | Alex Thompson | 2025-01-10 |
| 5 | 1 | 12 | 2025-06-28 | 2025-08-24 | canceled | 43 | 1 | card | 0 | Jordan Lee | 2025-06-28 |
| 5 | 1 | 12 | 2025-06-28 | 2025-08-24 | canceled | 43 | 1 | card | 0 | Jordan Lee | 2025-06-28 |
| 1 |
| 1 |
| 39 | 9 | 1 | 2025-05-23 | active | 1 |
| 39 | 9 | 1 | 2025-05-23 | active | 1 |
| 29 | 4 | 3 | 2025-05-06 | active | 1 |
| 29 | 4 | 3 | 2025-05-06 | active | 1 |
| 60 | 12 | 10 | 2025-05-05 | active | 1 |
| 60 | 12 | 10 | 2025-05-05 | active | 1 |