SQL Join and Filter Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Join and Filter Query. 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 need to log in / sign up to run or submit.

Problem

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

Tablescampaign_performance

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results