Write SQL and Python, run instantly in your browser, and track your progress.
You are a Customer Success Analyst at HubSpot. The Account Management team needs to understand customer tenure by calculating how many days each organization has been with the platform. Calculate the age in days from created_at to a reference date of '2025-09-01'.
| Column Name | Type |
|---|---|
| org_id | int64 |
| org_name | object |
| industry | object |
| size_bucket | object |
You are a Customer Success Analyst at HubSpot. The Account Management team needs to understand customer tenure by calculating how many days each organization has been with the platform. Calculate the age in days from created_at to a reference date of '2025-09-01'.
| Column Name | Type |
|---|---|
| org_id | int64 |
| org_name | object |
| industry | object |
| size_bucket | object |
| status | object |
| status | object |
| created_at | object |
| created_at | object |
| org_id | org_name | industry | size_bucket | status | created_at |
|---|---|---|---|---|---|
| 1 | Vivid Data | software | mid | active | 2025-06-07 |
| 2 | Edge Software | fintech |
| org_id | org_name | industry | size_bucket | status | created_at |
|---|---|---|---|---|---|
| 1 | Vivid Data | software | mid | active | 2025-06-07 |
| 2 | Edge Software | fintech |
| org_id | org_name | created_at | age_days |
|---|---|---|---|
| 1 | Vivid Data | 2025-06-07 | 86 |
| 2 | Edge Software | 2024-12-11 | 264 |
| 3 | Wind Works | 2025-02-22 | 191 |
| 4 | Motion Dynamics | 2025-02-24 | 189 |
| org_id | org_name | created_at | age_days |
|---|---|---|---|
| 1 | Vivid Data | 2025-06-07 | 86 |
| 2 | Edge Software | 2024-12-11 | 264 |
| 3 | Wind Works | 2025-02-22 | 191 |
| 4 | Motion Dynamics | 2025-02-24 | 189 |
Showing first 5 of 50 rows.
Showing first 5 of 50 rows.
1. Data Selection:
2. DateTime Operations:
3. Output:
1. Data Selection:
2. DateTime Operations:
3. Output:
| small |
| small |
| active |
| active |
| 2024-12-11 |
| 2024-12-11 |
| 3 | Wind Works | devtools | small | trial | 2025-02-22 |
| 3 | Wind Works | devtools | small | trial | 2025-02-22 |
| 4 | Motion Dynamics | legaltech | enterprise | active | 2025-02-24 |
| 4 | Motion Dynamics | legaltech | enterprise | active | 2025-02-24 |
| 5 | Upward Intelligence | fintech | mid | active | 2025-07-19 |
| 5 | Upward Intelligence | fintech | mid | active | 2025-07-19 |
| 5 | Upward Intelligence | 2025-07-19 | 44 |
| 5 | Upward Intelligence | 2025-07-19 | 44 |