Top Three Lanes Per Month

Phoenix International Freight Services wants to identify its busiest shipping lanes over the most recent rolling year. Write a SQL query that finds the top three complete origin-destination lanes for each month.

Output

1. Return one row per qualifying lane and month with columns month, origin_port, destination_port, shipment_count, and lane_rank.
2. Include shipments from the 12-month period beginning on the first day of the month 11 months before September 2026 and ending before October 2026. Exclude rows where either port is NULL.
3. Rank lanes within each month by shipment count descending. Break ties alphabetically by origin port, then destination port. Return at most three lanes per month.
4. Order the result chronologically by month and then by lane rank.