Write a SQL query to identify the top 10 most-watched shows in a specific region for the last month.
Use India as the target region. Treat total watch minutes as the measure of being most-watched, and consider viewing events from the previous calendar month only.
Output
- One row per qualifying show with
show_title, total_watch_minutes, and watch_sessions.
- Include only shows viewed in India during the previous calendar month.
- Order by
total_watch_minutes descending, then show_id ascending to break ties. Return at most 10 rows.
