Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You're analyzing video lengths on TikTok using the user_videos table.
The team wants you to to find the lengths of the shortest and longest videos. As a condition, they only want you to consider videos with at least 1000 views to ensure popularity and at least 3 seconds of length.
Note: the video_length column is in seconds.
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 |
You're analyzing video lengths on TikTok using the user_videos table.
The team wants you to to find the lengths of the shortest and longest videos. As a condition, they only want you to consider videos with at least 1000 views to ensure popularity and at least 3 seconds of length.
Note: the video_length column is in seconds.
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 |
| shortest_video | longest_video |
|---|---|
| 4 | 50 |
| 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 |
| shortest_video | longest_video |
|---|---|
| 4 | 50 |