Most Recent Status per Shipment

Return the latest status event for every shipment. Order events by status_at descending, then event_id descending so a higher event_id wins a timestamp tie. Return shipment_id, status, status_at and event_id. Return columns: shipment_id, status, status_at, event_id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Return the latest status event for every shipment. Order events by status_at descending, then event_id descending so a higher event_id wins a timestamp tie. Return shipment_id, status, status_at and event_id. Return columns: shipment_id, status, status_at, event_id.

Difficulty: Advanced
SQL concept: Window Functions