How do you use SQL to perform data manipulations in complex queries?
Use the provided tables to produce creator-level performance metrics for videos published in January 2025. Include creators without qualifying videos or views, and classify and rank creators based on their January activity.
Output
- One row per creator, with
creator_id, creator_name, video_count, total_views, total_watch_seconds, avg_watch_seconds, engagement_label, and creator_rank.
- Include all creators, order by
total_watch_seconds descending and creator_id ascending for ties.
