SQL for Dataset Analysis | Dataford Interview Questions

Write an SQL query to analyze a dataset and then write another query to go over it.

Use the supplied campaigns and ad_events tables. The first query should create a campaign-level analysis for January 2025. The second query should review campaigns with at least one impression by ranking them within each objective by click-through rate.

Output

One row per campaign with January impressions, clicks, spend, CTR percentage, and objective rank
Include only campaigns with at least one January impression
Return columns named campaign_id, campaign_name, objective, impressions, clicks, spend, ctr_pct, and objective_rank
Order by objective, objective_rank, then campaign_id

Schema

campaigns

Column	Type	Description
campaign_idPK	INT	Unique campaign identifier
campaign_name	VARCHAR(100)	Campaign name
objective	VARCHAR(30)	Campaign objective

ad_events

Column	Type	Description
event_idPK	INT	Unique event identifier
campaign_id	INT	Campaign associated with the event
event_date	DATE	Date on which the event occurred
event_type	VARCHAR(20)	Event category
cost	DECIMAL(10,2)	Cost associated with the event

Your question is SQL for Dataset Analysis. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem