Latest row per key (deduplicate by latest timestamp)

Table events:

Each entity has many rows, one per status change. Write a query that returns the latest row for every entity: the one with the greatest updated_at. If two rows of an entity share the greatest updated_at, keep the one with the larger id.

Return the columns entity_id, status and updated_at, one row per entity.

CREATE TABLE events (
  id int PRIMARY KEY,
  entity_id int NOT NULL,
  status text NOT NULL,
  updated_at timestamptz NOT NULL
);