Write a query to identify users who dropped off after the first 5 minutes of a video on Hotstar.
Treat a drop-off as a viewing session where the user watched at least 300 seconds but did not watch the video to completion. Return qualifying sessions only.
session_id, user_id, user_name, video_id, video_title, and watched_secondswatched_seconds descending, then user_id ascending and video_id ascending| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Hotstar user identifier |
| user_name | VARCHAR(100) | Display name of the user |
| VARCHAR(255) | User email address |
| Column | Type | Description |
|---|---|---|
| video_idPK | VARCHAR(20) | Unique Hotstar video identifier |
| video_title | VARCHAR(200) | Video title |
| duration_seconds | INT | Full video duration in seconds |
| Column | Type | Description |
|---|---|---|
| session_idPK | INT | Unique viewing session identifier |
| user_id | INT | User who watched the video |
| video_id | VARCHAR(20) | Video watched during the session |
| watched_seconds | INT | Maximum playback position reached in seconds |