Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at Salesforce. The Sales team wants to analyze which email domains are most common among users to identify potential enterprise deals. Extract the domain portion from user email addresses.
| Column Name | Type |
|---|---|
| user_id | int64 |
| org_id | int64 |
| object | |
| full_name | object |
You are a Data Analyst at Salesforce. The Sales team wants to analyze which email domains are most common among users to identify potential enterprise deals. Extract the domain portion from user email addresses.
| Column Name | Type |
|---|---|
| user_id | int64 |
| org_id | int64 |
| object | |
| full_name | object |
| role | object |
| role | object |
| seat_type | object |
| seat_type | object |
| status | object |
| status | object |
| mfa_enabled | int64 |
| mfa_enabled | int64 |
| created_at | object |
| created_at | object |
| last_login | object |
| last_login | object |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | email_domain | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner | full | active | 1 | 2025-07-29 |
| user_id | org_id | full_name | role | seat_type | status | mfa_enabled | created_at | last_login | email_domain | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | feng.ferrari@vividdata.app | Feng Ferrari | owner | full | active | 1 | 2025-07-29 |
Showing first 5 of 224 rows.
Showing first 5 of 224 rows.
1. Data Selection:
2. String Transformation:
3. Output:
1. Data Selection:
2. String Transformation:
3. Output:
| full |
| full |
| active |
| active |
| 1 |
| 1 |
| 2025-07-29 |
| 2025-07-29 |
| 2025-08-31 20:18:24 |
| 2025-08-31 20:18:24 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 |
| 2025-08-31 20:18:24 |
| 2025-08-31 20:18:24 |
| vividdata.app |
| vividdata.app |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 | NaN | vividdata.app |
| 2 | 1 | tao@vividdata.app | Tao Schneider | viewer | full | invited | 1 | 2025-08-18 | NaN | vividdata.app |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 | NaN | vividdata.app |
| 3 | 1 | fang.al-farsi@vividdata.app | Fang Al-Farsi | member | full | invited | 0 | 2025-07-18 | NaN | vividdata.app |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 | NaN | vividdata.app |
| 4 | 1 | rennakamura@vividdata.app | Ren Nakamura | member | full | deleted | 0 | 2025-06-17 | NaN | vividdata.app |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 | NaN | vividdata.app |
| 5 | 1 | ychoi@vividdata.app | Yan Choi | admin | read_only | active | 1 | 2025-07-02 | NaN | vividdata.app |