Top Underperforming Regions by Conversion | Dataford Interview Questions

Walmart Labs Operations uses regional funnel metrics to monitor performance across its commerce network. Write a PostgreSQL query that identifies the five regions with the lowest conversion rates during the last completed calendar quarter.

Requirements

Filter metrics to the last completed calendar quarter using PostgreSQL date functions.
Aggregate sessions and conversions by region, treating NULL conversions as zero.
Calculate conversion rate as total conversions divided by total sessions.
Return the five lowest conversion rates, breaking ties alphabetically by region name. Exclude regions without recorded sessions.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique regional identifier
region_name	VARCHAR(50)	Walmart Labs operating region name

regional_funnel_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
region_id	INT	Referenced operating region
metric_date	DATE	Date covered by the metric record
sessions	INT	Number of customer sessions
conversions	INT	Number of completed conversions

Your question is Top Underperforming Regions by Conversion. 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