Write SQL and Python, run instantly in your browser, and track your progress.
You are a Trust & Safety Analyst at X (formerly Twitter). The Verification team needs to audit all verified accounts that are currently active. These accounts have higher visibility and influence, so regular review is essential. Filter the users DataFrame to find accounts that are both verified AND have active status.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
You are a Trust & Safety Analyst at X (formerly Twitter). The Verification team needs to audit all verified accounts that are currently active. These accounts have higher visibility and influence, so regular review is essential. Filter the users DataFrame to find accounts that are both verified AND have active status.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object |
| object |
| country | object |
| country | object |
| join_date | object |
| join_date | object |
| account_status | object |
| account_status | object |
| is_verified | int64 |
| is_verified | int64 |
| bio | object |
| bio | object |
| user_id | username | full_name | country | join_date | account_status | is_verified | bio | |
|---|---|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | andrea.davis@gmail.com | AU | 2025-03-31 19:11:04 |
| user_id | username | full_name | country | join_date | account_status | is_verified | bio | |
|---|---|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | andrea.davis@gmail.com | AU | 2025-03-31 19:11:04 |
| user_id | username | full_name | is_verified | account_status |
|---|---|---|---|---|
| 51 | joshua.wang | Joshua Wang | 1 | active |
| 3 | karen_wilson | Karen Wilson | 1 | active |
| 50 | liam.gonzalez | Liam Gonzalez | 1 | active |
| user_id | username | full_name | is_verified | account_status |
|---|---|---|---|---|
| 51 | joshua.wang | Joshua Wang | 1 | active |
| 3 | karen_wilson | Karen Wilson | 1 | active |
| 50 | liam.gonzalez | Liam Gonzalez | 1 | active |
5 rows returned.
5 rows returned.
1. Data Selection:
2. Filtering:
3. Output:
1. Data Selection:
2. Filtering:
3. Output:
| active |
| active |
| 0 |
| 0 |
| 2 | its_emily | Emily Anderson | emily.anderson@proton.me | DE | 2025-02-10 22:12:29 | active | 0 | Entrepreneur | crypto enthusiast | Tokyo |
| 2 | its_emily | Emily Anderson | emily.anderson@proton.me | DE | 2025-02-10 22:12:29 | active | 0 | Entrepreneur | crypto enthusiast | Tokyo |
| 3 | karen_wilson | Karen Wilson | karen.wilson@yahoo.com | ES | 2025-04-23 11:08:04 | active | 1 | travel lover. Student. Living my best life. |
| 3 | karen_wilson | Karen Wilson | karen.wilson@yahoo.com | ES | 2025-04-23 11:08:04 | active | 1 | travel lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | liam.o'brien@gmail.com | AU | 2025-06-28 05:31:09 | active | 1 | reading lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | liam.o'brien@gmail.com | AU | 2025-06-28 05:31:09 | active | 1 | reading lover. Student. Living my best life. |
| 5 | liam21 | Liam Patel | liam.patel@proton.me | SG | 2025-05-10 16:07:39 | active | 0 | nature | photography | Tokyo based |
| 5 | liam21 | Liam Patel | liam.patel@proton.me | SG | 2025-05-10 16:07:39 | active | 0 | nature | photography | Tokyo based |
| 4 | liam80 | Liam O'Brien | 1 | active |
| 4 | liam80 | Liam O'Brien | 1 | active |
| 59 | the_barbara | Barbara Lee | 1 | active |
| 59 | the_barbara | Barbara Lee | 1 | active |