Top keywords and advertisers
You're given the following table that shows spend by keyword, advertiser, and unique ad ID:
Using the table above, write a SQL query that returns each keyword along with the advertiser_id of the top spending advertiser, and total spend on the keyword (agnostic of advertiser). Sort the results in descending order by the total spend on the keyword.
You can view/query the data in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now