Write a SQL query to find the top five most viewed shows on Hulu in the last month.
Treat “last month” as the previous calendar month relative to the current date. Include shows with no qualifying views only if needed for ranking, and count each viewing event once.
show_id, show_title, and total_views.total_views descending, with show_id ascending as the tie-breaker.| Column | Type | Description |
|---|---|---|
| show_idPK | INT | Unique identifier for the Hulu show |
| show_title | VARCHAR(150) | Show title |
| genre | VARCHAR(80) | Primary show genre |
| Column | Type | Description |
|---|---|---|
| view_idPK | INT | Unique identifier for a viewing event |
| show_id | INT | Identifier of the viewed show |
| viewed_at | TIMESTAMP | Timestamp when the show was viewed |
| device_type | VARCHAR(40) | Device category used for viewing |