Interview Guides
You are given campaign delivery data from StackAdapt and need to identify the top five ad campaigns by total spend for each month in the past year. Write a SQL query that returns one row per campaign-month, ranks campaigns within each month by spend, and keeps only the top five campaigns for each month.
