Top keywords for advertiser spend
Question
You’re given a table called total_ad_spend_by_keywords with the following schema:
| Column Name | Description | Data Type |
|---|---|---|
| keyword | Keyword the ad is running against | string |
| ad_id | Unique ID of the advert | integer |
| advertiser_id | Unique ID of the advertiser | integer |
| total_spend | Total spend against the given keyword, ad_id, and advertiser combination | integer |
Given this, write SQL a query to return the keywords with the most spend, and provide the top 5 advertisers advertising against those keywords.