Most Viewed Titles (unique viewers)

Custom SQL query returning 4 rows (hide)

SELECT pr.tmdb_id,
       pr.media_type,
       COUNT(DISTINCT pr.profile_id) AS unique_viewers,
       SUM(pr.completed) AS completions,
       ROUND(AVG(pr.position_seconds) / 60.0, 0) AS avg_position_min
FROM progress pr GROUP BY pr.tmdb_id, pr.media_type ORDER BY unique_viewers DESC, completions DESC LIMIT 30

Edit SQL