Your question is Top Underperforming Regions by Conversion. Start with the requirements and the two tables 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.
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.
| Column | Type | Description |
|---|---|---|
| region_idPK | INT | Unique regional identifier |
| region_name | VARCHAR(50) | Walmart Labs operating region name |
| 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 |