Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You're analyzing data the user_videos table from Tiktok (you probably know it by heart now)
Calculate the average number of views for videos that are longer than 30 seconds. Adjust the results to show whole numbers only, with no decimal points.
Hint: To round the number to no decimal points, you can use the ROUND function.
Example: ROUND(column_name)
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 |
You're analyzing data the user_videos table from Tiktok (you probably know it by heart now)
Calculate the average number of views for videos that are longer than 30 seconds. Adjust the results to show whole numbers only, with no decimal points.
Hint: To round the number to no decimal points, you can use the ROUND function.
Example: ROUND(column_name)
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 |
| rounded_average |
|---|
| 2601 |
| 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 |
| rounded_average |
|---|
| 2601 |