Write a PostgreSQL query to identify the worst-performing retailer in each region for January 2024. Use fulfillment rate defined as delivered orders divided by all non-cancelled orders. Only include retailers with at least 2 non-cancelled orders in the month, and rank retailers within each region from worst to best.
| Column | Type | Description |
|---|---|---|
| region_id | ||
| region_name |
| Column | Type | Description |
|---|---|---|
| retailer_id | ||
| retailer_name | ||
| region_id |
| Column | Type | Description |
|---|---|---|
| order_id | ||
| retailer_id | ||
| order_date | ||
| order_status |
Return one row per region for the lowest-ranked retailer, including ties if they exist.Include region name, retailer name, non-cancelled orders, delivered orders, fulfillment rate, and rank.Sort the final output by region name and retailer name.