Write a query to find the top three most-watched movies on Disney+ for each region over the last 30 days.
Use the movies and viewing_events tables. Count viewing events, include only events from the last 30 days relative to the current date, and return exactly three movies per region when available. Ties are resolved by ascending movie_id.
region, movie_title, watch_count, and movie_rankregion ascending, then movie_rank ascending| Column | Type | Description |
|---|---|---|
| movie_idPK | INT | Unique identifier for a Disney+ movie |
| movie_title | VARCHAR(150) | Movie title displayed on Disney+ |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique viewing event identifier |
| movie_id | INT | Movie watched during the event |
| region | VARCHAR(50) | Viewer region |
| watched_at | DATE | Date of the viewing event |