Task

Meta’s event pipeline for Facebook activity can receive the same logical event multiple times, and some duplicates arrive late. Write a SQL query to return one canonical row per event_id, keeping the most recently ingested record.

Requirements

1. Only consider events with a non-null event_id.
2. Deduplicate by event_id across the full table, even if duplicates arrive on different ingestion dates.
3. Keep the row with the greatest ingested_at for each event_id.
4. If two rows for the same event_id have the same ingested_at, keep the one with the greater record_id.
5. Return event_id, user_id, event_name, event_time, and ingested_at.
6. Order the final result by event_id ascending.

Table Definition

Sample Data

Expected Output