SQL for Top Converting Channels | Dataford Interview Questions

Write a query to identify the top 3 performing marketing channels by conversion rate at Veeva Systems.

Use the marketing_channels and marketing_leads tables. Treat leads with status = 'converted' as conversions and exclude channels with no leads.

Output

Return one row per selected channel with channel_name, total_leads, conversions, and conversion_rate.
Calculate conversion_rate as converted leads divided by total leads, expressed as a percentage rounded to two decimal places.
Sort by conversion rate descending, then total leads descending, then channel name ascending. Return only three rows.

marketing_channels

Column	Type	Description
channel_idPK	INT	Unique identifier for a marketing channel
channel_name	VARCHAR(100)	Name of the marketing channel

marketing_leads

Column	Type	Description
lead_idPK	INT	Unique identifier for a marketing lead
channel_id	INT	Marketing channel that generated the lead
status	VARCHAR(30)	Current lifecycle status of the lead

Your question is SQL for Top Converting Channels. 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.