Write a SQL query to extract specific data from a database for Dhl Supply Chain reporting or analytics.
Using the supplied tables, report January 2025 shipment performance for every facility, including facilities with no January shipments.
facility_code, facility_name, report_month, total_shipments, delivered_shipments, on_time_deliveries, and on_time_percentage.facility_code ascending.| Column | Type | Description |
|---|---|---|
| facility_idPK | INT | Unique facility identifier |
| facility_code | VARCHAR(20) | Operational facility code |
| facility_name | VARCHAR(100) | Facility display name |
| country_code | VARCHAR(2) | ISO country code |
| Column | Type | Description |
|---|---|---|
| shipment_idPK | INT | Unique shipment identifier |
| shipment_reference | VARCHAR(30) | Shipment reference used in reporting |
| facility_id | INT | Originating facility identifier |
| shipped_at | TIMESTAMP | Shipment dispatch timestamp |
| promised_at | TIMESTAMP | Promised delivery timestamp |
| delivered_at | TIMESTAMP | Actual delivery timestamp |
| status | VARCHAR(20) | Current shipment status |