Main SQL Data Operators | Dataford Interview Questions

What are the main SQL data operators

Using the provided campaign_metrics table, write a query that demonstrates common SQL data operations by returning metrics for active records only. Aggregate results by channel, sort by total spend, and return the three highest-spending channels.

Output

One row per channel, with channel, total_spend, and total_conversions.
Include only active records, ordered by total_spend descending.

Schema

campaign_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
channel	VARCHAR(50)	Channel associated with the metric record
status	VARCHAR(20)	Record status
spend	DECIMAL(10,2)	Spend attributed to the record
conversions	INT	Number of conversions attributed to the record

Your question is Main SQL Data Operators. 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

What are the main SQL data operators

Output

One row per channel, with channel, total_spend, and total_conversions.
Include only active records, ordered by total_spend descending.

Schema

campaign_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
channel	VARCHAR(50)	Channel associated with the metric record
status	VARCHAR(20)	Record status
spend	DECIMAL(10,2)	Spend attributed to the record
conversions	INT	Number of conversions attributed to the record

Your question is Main SQL Data Operators. 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.