Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Using the user_videos table, the Product Manager has requested you some specific metrics to gain insights into user engagement on TikTok, specifically focusing on videos with over 3,000 views:
user_videos table:
| Column Name | Data Type | Description |
|---|---|---|
| video_id | integer | Unique identifier for each video |
| user_id | integer | Identifier of the user who uploaded the video |
| video_length |
| integer |
| Duration of the video in seconds |
| upload_date | date | Date when the video was uploaded |
| views | integer | Number of times the video has been viewed |
| likes | integer | Number of likes the video has received |
| earliest_video | nb_video_creators | latest_video |
|---|---|---|
| 2021-01-05 | 13 | 2021-12-28 |
Using the user_videos table, the Product Manager has requested you some specific metrics to gain insights into user engagement on TikTok, specifically focusing on videos with over 3,000 views:
user_videos table:
| Column Name | Data Type | Description |
|---|---|---|
| video_id | integer | Unique identifier for each video |
| user_id | integer | Identifier of the user who uploaded the video |
| video_length | integer | Duration of the video in seconds |
| upload_date | date | Date when the video was uploaded |
| views | integer | Number of times the video has been viewed |
| likes | integer | Number of likes the video has received |
| earliest_video | nb_video_creators | latest_video |
|---|---|---|
| 2021-01-05 | 13 | 2021-12-28 |