Who Are Our Top Viewers, Ranked?

StreamVerse's engagement team is building a viewer leaderboard for an internal dashboard. A single "most active subscriber" badge was the first version and it turned out to be useless: it never changed, and it said nothing about how far ahead the leader actually was. This time they want the whole board — every subscriber, their total, and their position on it.

The awkward part is that the position depends on a number that does not exist yet. Nobody's total watch time is stored; it is spread across however many sessions they logged, three for one subscriber and one for another. The positions can only be worked out once those totals exist.

watch_events — one row per viewing session. subscriber_id is the subscriber who watched. watch_minutes is how long that session lasted.

The table already exists in the database — there is nothing to create or load.

Task: Write a query returning three columns, subscriber_id, total_minutes and viewer_rank, with one row per subscriber who has logged at least one session. total_minutes is that subscriber's minutes across all their sessions. viewer_rank is their position on the board, 1 for the highest total. Two subscribers on exactly the same total share a position, and the position straight after it is skipped, so a board can read 1, 2, 2, 4. A subscriber with no sessions at all does not appear. Rows come back sorted by viewer_rank, best position first, and two subscribers sharing a position by subscriber_id.

Example output — shape only, on an invented board; the two subscribers level on 180 minutes show the shared position and the skip that follows it.