Join Data Science Interview MasterClass (in 3 weeks) 🚀 led by FAANG Data Scientists | Just 6 seats remaining...

Back to Questions

14. Top Viewers

easy
TikTokTikTok
senior
tiktok_dim_users
Column NameType
user_idint64
user_nameobject
signup_tsobject
countryobject
suspicious_accountint64
tiktok_fct_views
Column NameType
viewer_idint64
creator_idint64
view_tsobject
device_typeobject
viewed_to_completionint64
sound_idint64
has_promotionint64
Expected Output Schema
Column NameType
user_nameobject
total_viewsint64

Constraints

Roles
Data Analyst
Analytics Engineer
Data Engineer
Business Intelligence Engineer
Data Scientist
Product Manager
ML Engineer
AI Engineer
Companies
TikTokTikTok
Levels
senior
entry
Tags
SQL
aggregation
group-by
joins
ties

Similar Questions

Ad CTR Calculationeasy
database
Top 3 Click Rateseasy
database
Artists' Top-10 Songseasy
database
40 people are solving this problem
Python LogoPython Editor
Ln 1, Col 1

Input Arguments

Edit values below to test with custom inputs

You need tolog in/sign upto run or submit