Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Top Pinnacle Campaigns by Spend

EasyJoinsData WranglingAggregations

Problem

Task

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.

Problem

Task

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.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Stackadapt

Top Monthly Campaign Spend RankingMedium

PNC Financial Services Group

Summarize Campaign Results for LeadershipEasy

PENFED Credit Union

Monthly Campaign Performance SummaryEasy

Top Pinnacle Campaigns by Spend | Dataford Interview Questions