Write a SQL query to find the top 3 articles by views within each section for each day.
Use the article metadata and daily article view records. Return only articles with recorded view data, rank ties by the lower article_id, and exclude articles ranked below third place.
view_date, section, article_id, title, total_views, and article_rank.view_date, section, and article_rank ascending.| Column | Type | Description |
|---|---|---|
| article_idPK | INT | Unique CNN article identifier |
| section | VARCHAR(100) | CNN content section containing the article |
| title | VARCHAR(255) | Article headline |
| Column | Type | Description |
|---|---|---|
| view_idPK | INT | Unique view summary record identifier |
| article_id | INT | Referenced CNN article |
| view_date | DATE | Date associated with the view count |
| views | INT | Number of article views recorded for the date |