Which users have the highest number of clips watched, and what are their user_name and total_views? Compute total_views as the count of view events in tiktok_fct_views per viewer_id, and return all users tied for the maximum total_views. Order the results by user_name in ascending order.

User Comment Totals

List distinct room types

Top Viewers

Practice this medium level coding question from TikTok. Master SQL, Python, and Algorithms for Data Science interviews.

Column Name	Type
user_id	int64
user_name	object
signup_ts	object
country	object
suspicious_account	int64

Column Name	Type
viewer_id	int64
creator_id	int64
view_ts	object
device_type	object
viewed_to_completion	int64
sound_id	int64
has_promotion	int64

Column Name	Type
user_name	object
total_views	int64

14. Top Viewers

Constraints

Similar Questions

Input Arguments