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.
Output details
- Treat
DATE '2026-09-15' as today's date.
- Treat NULL
watch_minutes as 0 when summing, and count every qualifying viewing-event row as a watch_session without deduplication.