Write SQL and Python, run instantly in your browser, and track your progress.
You are a Customer Success Manager at Salesforce. The Account Management team needs a list of all organizations with active accounts for quarterly business reviews. Filter the organizations DataFrame to find all companies with 'active' status.
| Column Name | Type |
|---|---|
| org_id | int64 |
| org_code | object |
| org_name | object |
| industry | object |
You are a Customer Success Manager at Salesforce. The Account Management team needs a list of all organizations with active accounts for quarterly business reviews. Filter the organizations DataFrame to find all companies with 'active' status.
| Column Name | Type |
|---|---|
| org_id | int64 |
| org_code | object |
| org_name | object |
| industry | object |
| size_bucket | object |
| size_bucket | object |
| country | object |
| country | object |
| state | object |
| state | object |
| city | object |
| city | object |
| primary_domain | object |
| primary_domain | object |
| status | object |
| status | object |
| created_at | object |
| created_at | object |
| org_id | org_code | org_name | industry | size_bucket | country | state | city | primary_domain | status | created_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ORG00001 | Vivid Data | software |
| org_id | org_code | org_name | industry | size_bucket | country | state | city | primary_domain | status | created_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ORG00001 | Vivid Data | software |
| org_id | org_name | industry | status |
|---|---|---|---|
| 18 | Azure Data | manufacturing | active |
| 23 | Coral Industries | healthtech | active |
| 22 | Core Networks | software | active |
| 2 | Edge Software | fintech | active |
| org_id | org_name | industry | status |
|---|---|---|---|
| 18 | Azure Data | manufacturing | active |
| 23 | Coral Industries | healthtech | active |
| 22 | Core Networks | software | active |
| 2 | Edge Software | fintech | active |
Showing first 5 of 30 rows.
Showing first 5 of 30 rows.
1. Data Selection:
2. Filtering:
3. Output:
1. Data Selection:
2. Filtering:
3. Output:
| mid |
| mid |
| US |
| US |
| MA |
| MA |
| Boston |
| Boston |
| vividdata.app |
| vividdata.app |
| active |
| active |
| 2025-06-07 |
| 2025-06-07 |
| 2 | ORG00002 | Edge Software | fintech | small | US | TN | Nashville | edgesoftware.tech | active | 2024-12-11 |
| 2 | ORG00002 | Edge Software | fintech | small | US | TN | Nashville | edgesoftware.tech | active | 2024-12-11 |
| 3 | ORG00003 | Wind Works | devtools | small | US | CA | San Francisco | windworks.io | trial | 2025-02-22 |
| 3 | ORG00003 | Wind Works | devtools | small | US | CA | San Francisco | windworks.io | trial | 2025-02-22 |
| 4 | ORG00004 | Motion Dynamics | legaltech | enterprise | US | CA | Los Angeles | motiondynamics.ai | active | 2025-02-24 |
| 4 | ORG00004 | Motion Dynamics | legaltech | enterprise | US | CA | Los Angeles | motiondynamics.ai | active | 2025-02-24 |
| 5 | ORG00005 | Upward Intelligence | fintech | mid | US | TX | Houston | upwardintelligence.com | active | 2025-07-19 |
| 5 | ORG00005 | Upward Intelligence | fintech | mid | US | TX | Houston | upwardintelligence.com | active | 2025-07-19 |
| 28 | Emerge Automation | govtech | active |
| 28 | Emerge Automation | govtech | active |