Disney+ Hotstar's Product Analytics team wants to identify the strongest-performing content in January 2026. Write a PostgreSQL query that ranks content within each content type using watch-time metrics.
content_type.content_type, title, total_watch_minutes, avg_completion_pct, performance_rank.DATE '2026-01-01' inclusively through DATE '2026-02-01' exclusively.avg_completion_pct to two decimal places and return total_watch_minutes as an integer.total_watch_minutes descending, then avg_completion_pct descending with NULLs last, then title ascending.content_type ascending, then performance_rank ascending.| Column | Type | Description |
|---|---|---|
| content_idPK | INTEGER | Unique content identifier |
| title | VARCHAR(150) | Content title |
| content_type | VARCHAR(30) | Content category |
| Column | Type | Description |
|---|---|---|
| session_idPK | INTEGER | Unique viewing session identifier |
| content_id | INTEGER | Watched content identifier |
| watched_at | DATE | Date of the viewing session |
| watch_minutes | INTEGER | Minutes watched in the session |
| completion_pct | INTEGER | Percentage of content completed |