Write a SQL query to find the total number of shipments processed per day over the last month for Fedex Services.
Use the previous calendar month as the reporting period. A shipment counts once per day, even if it has multiple processed events.
processed_date and shipment_count.processed_date ascending.| Column | Type | Description |
|---|---|---|
| shipment_idPK | INT | Unique shipment identifier |
| tracking_number | VARCHAR(30) | Shipment tracking number |
| service_type | VARCHAR(30) | FedEx shipment service type |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique processing event identifier |
| shipment_id | INT | Shipment associated with the event |
| status | VARCHAR(20) | Processing status recorded for the event |
| processed_at | TIMESTAMP | Timestamp when the event was recorded |