Movies vs TV — Breakdown

Custom SQL query returning 2 rows (hide)

SELECT pr.media_type,
       COUNT(DISTINCT pr.tmdb_id) AS unique_titles,
       COUNT(DISTINCT pr.profile_id) AS unique_viewers,
       SUM(pr.completed) AS completions,
       ROUND(SUM(pr.position_seconds) / 3600.0, 1) AS total_hours
FROM progress pr GROUP BY pr.media_type

Edit SQL