SQLmediumWindow functions~16m

A streaming platform wants to identify content that's experiencing 'viewership...

Problem

A streaming platform wants to identify content that's experiencing 'viewership momentum' - shows where each episode has more total watch time than the previous episode in the series. Write a query to find all episodes that have higher total watch time than their immediately preceding episode within the same series. Include the series title, episode number, current episode watch time, previous episode watch time, and the momentum percentage increase. Only include episodes where there is actually a previous episode to compare against.

Examples

Example 1

Example 2

Constraints

›Return columns: series_title, episode_number, current_watch_time, previous_watch_time, momentum_percentage
›Only include episodes that have higher watch time than the previous episode
›Calculate momentum_percentage as ((current - previous) / previous * 100) rounded to 2 decimal places
›Order by series_title, then episode_number

Reference solution

Reference solution available after you attempt the question.

Ready to solve it?

Start a session on Mockbit #46. Write your SQL, run it against real data, and get graded on correctness, efficiency, query structure, and business understanding.