Write a SQL query to find the top 10 most-watched shows in the last month.
Use the previous calendar month and define most-watched by the number of viewing sessions. Include shows with no sessions during that month only when needed to complete the top 10, and break ties by show_id ascending.
show_id, show_title, and watch_countwatch_count descending and show_id ascending| Column | Type | Description |
|---|---|---|
| show_idPK | INT | Unique identifier for a show |
| show_title | VARCHAR(150) | Display title of the show |
| Column | Type | Description |
|---|---|---|
| session_idPK | INT | Unique viewing session identifier |
| show_id | INT | Show watched during the session |
| started_at | TIMESTAMP | Timestamp when the viewing session started |