Write a query to find the top three busiest shipping hubs at UPS based on package volume over the last quarter.
Use the previous calendar quarter relative to the current date. Include hubs with no matching packages when calculating volumes.
hub_name and package_volume.hub_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| hub_idPK | INT | Unique identifier for the UPS shipping hub |
| hub_name | VARCHAR(100) | Name of the shipping hub |
| Column | Type | Description |
|---|---|---|
| package_idPK | INT | Unique identifier for the package |
| hub_id | INT | Shipping hub associated with the package |
| shipped_at | TIMESTAMP | Timestamp when the package was shipped |