Medium · 20 min
Identify the top 25 games by total playtime in the past 30 days. Return: game_id, game_name, category, total_playtime_hours, unique_players, sessions_count, avg_session_duration_minutes, and rank_by_playtime. Order by total_playtime_hours descending.
Tables: play_sessions, games
Hard · 25 min
Perform cohort analysis for users who joined in January, February, and March 2025. For each cohort and week (0-1, 1-2, 2-3, 3-4), return: join_cohort_month, week_number, users_in_cohort, active_users, retention_percent, total_playtime_hours, and avg_sessions_per_user.
Tables: users, play_sessions
Hard · 28 min
Analyze creator earnings for the past 12 months. Return creator_type (verified vs. non-verified), total_creators, median_monthly_robux, p95_monthly_robux, and p99_monthly_robux.
Tables: users, creators, games, revenue_shares