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 is conducting an audit of verified accounts that are in good standing. They need all verified users who are NOT suspended or banned. These accounts represent trusted voices on the platform.
This requires combining positive conditions (is_verified = 1) with negative conditions (excluding certain statuses).
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
You are a Trust & Safety Analyst at X (formerly Twitter). The Verification team is conducting an audit of verified accounts that are in good standing. They need all verified users who are NOT suspended or banned. These accounts represent trusted voices on the platform.
This requires combining positive conditions (is_verified = 1) with negative conditions (excluding certain statuses).
| 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 |
|---|---|---|---|---|
| 59 | the_barbara | Barbara Lee | 1 | active |
| 51 | joshua.wang | Joshua Wang | 1 | active |
| 3 | karen_wilson | Karen Wilson | 1 | active |
| user_id | username | full_name | is_verified | account_status |
|---|---|---|---|---|
| 59 | the_barbara | Barbara Lee | 1 | active |
| 51 | joshua.wang | Joshua Wang | 1 | active |
| 3 | karen_wilson | Karen Wilson | 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 |
| 50 | liam.gonzalez | Liam Gonzalez | 1 | active |
| 50 | liam.gonzalez | Liam Gonzalez | 1 | active |
| 4 | liam80 | Liam O'Brien | 1 | active |
| 4 | liam80 | Liam O'Brien | 1 | active |