Meta’s Instagram Reels team wants to identify the strongest creators by total watch time over the last 7 days. Write a SQL query to rank creators within each country and return the top 5 creators per country.
watch_date.watch_time_seconds for each creator within each country.creator_id.DATE '2025-05-17' as today's date.DATE '2025-05-11' through DATE '2025-05-17'.country, creator_id, creator_name, total_watch_time_seconds, country_rank.0 total watch time.country ascending, country_rank ascending, and creator_id ascending, with NULL countries last.| Column | Type | Description |
|---|---|---|
| creator_idPK | INT | Unique Instagram Reels creator identifier |
| creator_name | VARCHAR(100) | Creator display name |
| country | VARCHAR(50) | Creator home country |
| account_status | VARCHAR(20) | Creator account status such as active or paused |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique watch event identifier |
| viewer_id | INT | Viewer who watched the Reel |
| creator_id | INT | Creator whose Reel was watched |
| watch_date | DATE | Date of the watch event |
| watch_time_seconds | INT | Watch time contributed by the event in seconds |
| surface | VARCHAR(50) | Meta surface where the watch happened |