# TV Show Watch Time — SQL Question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3066/tv-show-watch-time
Source observed: 2026-11-04T23:34:24.113Z
Last checked: 2026-11-04T23:34:24.113+00:00
Indexed: 2026-11-06T15:58:06.732+00:00

---

# TV Show Watch Time

We provide interview-preparation questions through Aced (formerly Exponent). This **Medium** coding question is categorized under [Coding](https://www.aced.io/questions?type=coding) and [SQL](https://www.aced.io/questions?type=sql). It is associated with a coding interview and was last asked 3 years ago.

## Problem

Disney+ is a streaming platform with multiple shows and millions of subscribers. The objective is to identify star customers—viewers whose watch time increases over time.

You are given the table `watch_time`:

| viewer_id | show_id | year | month | watch_hours |
| --- | --- | --- | --- | --- |
| 1 | 101 | 2022 | 1 | 50.5 |
| 1 | 101 | 2022 | 2 | 62.7 |
| 1 | 101 | 2022 | 3 | 75.2 |
| 1 | 101 | 2022 | 4 | 82.6 |
| 2 | 102 | 2022 | 1 | 30.0 |
| 2 | 102 | 2022 | 2 | 33.6 |
| 2 | 102 | 2022 | 3 | 42.1 |
| 2 | 102 | 2022 | 4 | 50.9 |
| 3 | 103 | 2022 | 1 | 20.5 |
| 3 | 103 | 2022 | 2 | 25.7 |
| 3 | 103 | 2022 | 3 | 23.0 |
| 3 | 103 | 2022 | 4 | 35.8 |

Write an SQL query to identify viewers who received a month-over-month increase in watch time for at least 3 months. In other words, find viewers who consistently increased their watch time for a minimum of 3 consecutive months.

## Desired output

| viewer_id |
| --- |
| 1 |
| 2 |

Viewer 1 increases from 50.5 to 62.7 to 75.2 to 82.6, and viewer 2 increases from 30.0 to 33.6 to 42.1 to 50.9. Viewer 3 does not qualify because watch time falls from 25.7 hours in February to 23.0 hours in March.

## Available interaction

The question interface includes **Question**, **Solution**, and **Community** tabs, an editor and output panel, and a test-results panel. No community answers have been contributed yet. Running code requires an account; use [Sign up to run code](https://www.aced.io/signup?src=lesson). Detailed company statistics for this question require [Upgrade](https://www.aced.io/upgrade?src=questions).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3066%2Ftv-show-watch-time&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3066%2Ftv-show-watch-time). Opening a form does not execute a tool.