Write SQL and Python, run instantly in your browser, and track your progress.
You are a Growth Analyst at TikTok. The Creator Success team wants to identify top-performing content creators based on engagement with their published posts. Merge user data with posts and reactions to calculate engagement metrics per creator.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
You are a Growth Analyst at TikTok. The Creator Success team wants to identify top-performing content creators based on engagement with their published posts. Merge user data with posts and reactions to calculate engagement metrics per creator.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_type | object |
| status | object |
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_type | object |
| status | object |
| Column Name | Type |
|---|---|
| reaction_id | int64 |
| entity_type | object |
| entity_id | int64 |
| reaction_type | object |
| Column Name | Type |
|---|---|
| reaction_id | int64 |
| entity_type | object |
| entity_id | int64 |
| reaction_type | object |
| user_id | username | full_name |
|---|---|---|
| 1 | andrea4 | Andrea Davis |
| 2 | its_emily | Emily Anderson |
| 3 | karen_wilson | Karen Wilson |
| user_id | username | full_name |
|---|---|---|
| 1 | andrea4 | Andrea Davis |
| 2 | its_emily | Emily Anderson |
| 3 | karen_wilson | Karen Wilson |
| post_id | user_id | content_type | status |
|---|---|---|---|
| 1 | 1 | video | published |
| 2 | 1 | link | published |
| 3 | 1 | image | published |
| post_id | user_id | content_type | status |
|---|---|---|---|
| 1 | 1 | video | published |
| 2 | 1 | link | published |
| 3 | 1 | image | published |
| reaction_id | entity_type | entity_id | reaction_type |
|---|---|---|---|
| 1 | post | 1 | support |
| 2 | post | 1 | love |
| 3 | post | 2 |
| reaction_id | entity_type | entity_id | reaction_type |
|---|---|---|---|
| 1 | post | 1 | support |
| 2 | post | 1 | love |
| 3 | post | 2 |
| user_id | full_name | post_count | total_reactions | avg_reactions |
|---|---|---|---|---|
| 27 | Ananya Schneider | 7 | 46 | 6.57 |
| 3 | Karen Wilson | 6 | 29 | 4.83 |
| 16 | Ren Thompson | 7 | 29 | 4.14 |
| user_id | full_name | post_count | total_reactions | avg_reactions |
|---|---|---|---|---|
| 27 | Ananya Schneider | 7 | 46 | 6.57 |
| 3 | Karen Wilson | 6 | 29 | 4.83 |
| 16 | Ren Thompson | 7 | 29 | 4.14 |
Showing first 5 of 55 rows.
Showing first 5 of 55 rows.
1. Data Selection:
2. Join:
3. Aggregation:
4. Output:
1. Data Selection:
2. Join:
3. Aggregation:
4. Output:
| 4 | 2 | poll | published |
| 4 | 2 | poll | published |
| 5 | 2 | image | hidden |
| 5 | 2 | image | hidden |
| like |
| like |
| 4 | post | 3 | insightful |
| 4 | post | 3 | insightful |
| 5 | post | 3 | like |
| 5 | post | 3 | like |
| 55 | Isabella Anderson | 4 | 29 | 7.25 |
| 55 | Isabella Anderson | 4 | 29 | 7.25 |
| 49 | Andrew Anderson | 6 | 28 | 4.67 |
| 49 | Andrew Anderson | 6 | 28 | 4.67 |