Swiggy Operations wants to identify active delivery zones with the longest completed-order delivery times. Write a PostgreSQL query that returns the top 10% of qualifying zones by average delivery duration.
swiggy_zones with swiggy_deliveries using zone_id.status = 'DELIVERED' and non-null timestamps.CEIL(10% of qualifying zones), with ties resolved by zone_id.| Column | Type | Description |
|---|---|---|
| zone_idPK | INTEGER | Unique Swiggy delivery zone identifier |
| zone_name | VARCHAR(80) | Name of the delivery zone |
| city | VARCHAR(60) | City containing the zone |
| is_active | BOOLEAN | Whether the zone is currently active |
| Column | Type | Description |
|---|---|---|
| delivery_idPK | INTEGER | Unique delivery identifier |
| zone_id | INTEGER | Delivery zone associated with the order |
| status | VARCHAR(20) | Delivery lifecycle status |
| accepted_at | TIMESTAMP | Timestamp when the delivery was accepted |
| delivered_at | TIMESTAMP | Timestamp when the order was delivered |