Easy · 5 min
Identify active members who watched more than 50 hours of content during March 2026. Return member_id, subscription_type, country, and total_hours (rounded to 2 decimal places), sorted by total_hours in descending order.
Tables: viewing_history, members
Medium · 10 min
Calculate the average rating and number of ratings for each show by month. Return title_name, year_month (formatted as YYYY-MM), avg_rating (rounded to 2 decimals), and rating_count. Only include show (not movie) content. Filter to months/shows with at least 10 ratings. Order by year_month descending, then avg_rating descending.
Tables: titles, title_ratings
Hard · 15 min
Analyze content completion rates by genre and subscription type. A view is considered 'completed' if minutes_watched is at least 90% of the title's total_duration_minutes. Return genre, subscription_type, completion_rate (percentage, rounded to 2 decimals), total_views, and completed_views. Only include genre/subscription combinations with at least 100 total views. Order by completion_rate in descending order.
Tables: titles, viewing_history, members