Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at LinkedIn. The Growth team wants to analyze follower relationships and needs to see who each user is following, with the followee's full name included. The relationships table has 'followee_id' but users has 'user_id' - you'll need to use left_on and right_on to handle these different column names.
| Column Name | Type |
|---|---|
| follow_id | int64 |
| follower_id | int64 |
| followee_id | int64 |
| created_at |
You are a Data Analyst at LinkedIn. The Growth team wants to analyze follower relationships and needs to see who each user is following, with the followee's full name included. The relationships table has 'followee_id' but users has 'user_id' - you'll need to use left_on and right_on to handle these different column names.
| Column Name | Type |
|---|---|
| follow_id | int64 |
| follower_id | int64 |
| followee_id | int64 |
| created_at |
| object |
| object |
| status | object |
| status | object |
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object | |
| country | object |
| join_date | object |
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object | |
| country | object |
| join_date | object |
| follow_id | follower_id | followee_id | created_at | status |
|---|---|---|---|---|
| 1 | 1 | 7 | 2025-08-17 22:47:52 | active |
| 2 | 1 | 16 | 2025-08-15 18:38:27 | active |
| follow_id | follower_id | followee_id | created_at | status |
|---|---|---|---|---|
| 1 | 1 | 7 | 2025-08-17 22:47:52 | active |
| 2 | 1 | 16 | 2025-08-15 18:38:27 | active |
| 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 |
| follow_id | follower_id | followee_id | followee_name |
|---|---|---|---|
| 1 | 1 | 7 | Juan Hassan |
| 2 | 1 | 16 | Ren Thompson |
| 3 | 1 | 55 | Isabella Anderson |
| 4 | 1 | 9 | Deepa Yamamoto |
| follow_id | follower_id | followee_id | followee_name |
|---|---|---|---|
| 1 | 1 | 7 | Juan Hassan |
| 2 | 1 | 16 | Ren Thompson |
| 3 | 1 | 55 | Isabella Anderson |
| 4 | 1 | 9 | Deepa Yamamoto |
Showing first 5 of 486 rows.
Showing first 5 of 486 rows.
1. DataFrames:
2. Merge:
3. Output:
1. DataFrames:
2. Merge:
3. Output:
| account_status | object |
| account_status | object |
| is_verified | int64 |
| is_verified | int64 |
| bio | object |
| bio | object |
| 3 |
| 3 |
| 1 |
| 1 |
| 55 |
| 55 |
| 2025-07-03 11:47:43 |
| 2025-07-03 11:47:43 |
| active |
| active |
| 4 | 1 | 9 | 2025-05-18 03:03:10 | active |
| 4 | 1 | 9 | 2025-05-18 03:03:10 | active |
| 5 | 1 | 31 | 2025-04-28 21:15:53 | active |
| 5 | 1 | 31 | 2025-04-28 21:15:53 | active |
| 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 |
| 5 | 1 | 31 | Raj Kumar |
| 5 | 1 | 31 | Raj Kumar |