SQL Join and Filter Query | Dataford Interview Questions

Marketing Evolution analysts need a focused view of paid social campaign performance for a weekly review. Write a PostgreSQL query against the campaign_performance table to return qualifying campaign records.

Requirements

Return campaigns where channel is Paid Social and conversions is at least 10.
Select the campaign name, reporting date, spend, and conversions, then order results by reporting date from newest to oldest.

Schema

campaign_performance

Column	Type	Description
performance_idPK	INT	Unique performance record identifier
campaign_name	VARCHAR(120)	Marketing Evolution campaign name
channel	VARCHAR(40)	Advertising channel
report_date	DATE	Date represented by the performance record
spend	NUMERIC(12,2)	Campaign spend in USD
conversions	INT	Number of attributed conversions

Your question is SQL Join and Filter Query. Start with the requirements and the one table 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

Requirements

Return campaigns where channel is Paid Social and conversions is at least 10.
Select the campaign name, reporting date, spend, and conversions, then order results by reporting date from newest to oldest.

Schema

campaign_performance

Column	Type	Description
performance_idPK	INT	Unique performance record identifier
campaign_name	VARCHAR(120)	Marketing Evolution campaign name
channel	VARCHAR(40)	Advertising channel
report_date	DATE	Date represented by the performance record
spend	NUMERIC(12,2)	Campaign spend in USD
conversions	INT	Number of attributed conversions

Your question is SQL Join and Filter Query. Start with the requirements and the one table 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.