Top keywords for advertiser spend


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.


Access restricted

Subscribe to premium account to see the solution.

Get premium now