Write SQL and Python, run instantly in your browser, and track your progress.
You are a Community Operations Manager at Meta. The marketing team needs to identify verified influencers who can participate in a new creator monetization program launching next quarter.
Create a list of verified, active users. These users represent the platform's most trusted content creators. For each user, provide their user ID, username, full name, and country.
To prioritize outreach to the newest verified members first, sort by join date (most recent first). For ties, sort by user ID ascending.
| Column Name | Type |
|---|---|
| user_id | INTEGER |
| username | TEXT |
| full_name |
You are a Community Operations Manager at Meta. The marketing team needs to identify verified influencers who can participate in a new creator monetization program launching next quarter.
Create a list of verified, active users. These users represent the platform's most trusted content creators. For each user, provide their user ID, username, full name, and country.
To prioritize outreach to the newest verified members first, sort by join date (most recent first). For ties, sort by user ID ascending.
| Column Name | Type |
|---|---|
| user_id | INTEGER |
| username | TEXT |
| full_name |
| TEXT |
| TEXT |
| TEXT |
| TEXT |
| country | TEXT |
| country | TEXT |
| join_date | TEXT |
| join_date | TEXT |
| account_status | TEXT |
| account_status | TEXT |
| is_verified | INTEGER |
| is_verified | INTEGER |
| bio | TEXT |
| bio | TEXT |
| 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 | country |
|---|---|---|---|
| 4 | liam80 | Liam O'Brien | AU |
| 3 | karen_wilson | Karen Wilson | ES |
| 59 | the_barbara | Barbara Lee | AU |
| 51 | joshua.wang | Joshua Wang | SG |
| user_id | username | full_name | country |
|---|---|---|---|
| 4 | liam80 | Liam O'Brien | AU |
| 3 | karen_wilson | Karen Wilson | ES |
| 59 | the_barbara | Barbara Lee | AU |
| 51 | joshua.wang | Joshua Wang | SG |
5 rows returned. Verified, active accounts sorted by most recent join date.
5 rows returned. Verified, active accounts sorted by most recent join date.
1. Filtering:
is_verified = 1 (verified status)account_status = 'active' (active accounts only)2. Columns:
3. Ordering:
join_date descending (most recent first)user_id ascending1. Filtering:
is_verified = 1 (verified status)account_status = 'active' (active accounts only)2. Columns:
3. Ordering:
join_date descending (most recent first)user_id ascending| 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 | GB |
| 50 | liam.gonzalez | Liam Gonzalez | GB |