Write a SQL query to fetch top 5 influencers from Chennai in Facebook.
Use the influencers and social_accounts tables. Treat an influencer's total Facebook followers as the sum of followers across their Facebook accounts.
influencer_id, influencer_name, and total_facebook_followers.influencer_name ascending.| Column | Type | Description |
|---|---|---|
| influencer_idPK | INT | Unique influencer identifier |
| influencer_name | VARCHAR(150) | Influencer's display name |
| city | VARCHAR(100) | City associated with the influencer |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique social account identifier |
| influencer_id | INT | Influencer owning the account |
| platform | VARCHAR(50) | Social media platform |
| handle | VARCHAR(100) | Platform account handle |
| followers | INT | Follower count for the account |