You are given shipment records and a policy change date. Write a PostgreSQL query that compares shipping performance before and after the policy change by returning the number of shipped orders, average delivery time in days, and on-time delivery rate for each period.
Use delivered_at <= promised_delivery_at to define on-time delivery, and exclude rows with missing shipped_at or delivered_at values.