Write a query to find the top 10 most-watched shows in a specific region over the last 30 days on Hotstar.
Use IN as the target region and CURRENT_DATE as the reference date. Treat total watch_seconds as the measure of how much each show was watched.
show_id, show_title, and total_watch_seconds.total_watch_seconds descending, breaking ties by show_id ascending, and return at most 10 rows.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique viewing event identifier |
| show_id | INT | Show watched during the event |
| region | VARCHAR(10) | Viewer region code |
| watched_at | TIMESTAMP | Timestamp when the viewing event occurred |
| watch_seconds | INT | Number of seconds watched |
| Column | Type | Description |
|---|---|---|
| show_idPK | INT | Unique Hotstar show identifier |
| show_title | VARCHAR(150) | Display title of the show |
| content_type | VARCHAR(30) | Content classification |