Your question is Top Pinnacle Campaigns by Spend. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given a table of daily spend records from Pinnacle campaign reporting. Write a SQL query to return the top 3 campaign names by total spend, considering only rows where channel = 'Paid Search'. The result should show each campaign name and its total spend, sorted from highest to lowest total spend.
| Column | Type | Description |
|---|---|---|
| spend_idPK | INT | Unique row identifier for each spend record |
| campaign_name | VARCHAR(100) | Pinnacle campaign name |
| channel | VARCHAR(50) | Marketing channel tied to the spend record |
| spend_date | DATE | Date of the spend entry |
| spend_amount | DECIMAL(10,2) | Spend amount recorded for that row |