text: DROP TABLE IF EXISTS appointment_events;
  CREATE TABLE appointment_events
  (
      _appointment_id UInt32,
      _id String,
      _status String,
      _set_by_id String,
      _company_id String,
      _client_id String,
      _type String,
      _at String,
      _vacancy_id String,
      _set_at UInt32,
      _job_requisition_id String
  ) ENGINE = Memory;
  
  INSERT INTO appointment_events (_appointment_id, _set_at, _status) values (1, 1, 'Created'), (2, 2, 'Created');
  
  SELECT A._appointment_id,
         A._id,
         A._status,
         A._set_by_id,
         A._company_id,
         A._client_id,
         A._type,
         A._at,
         A._vacancy_id,
         A._set_at,
         A._job_requisition_id
  FROM appointment_events A ANY
  LEFT JOIN
    (SELECT _appointment_id,
            MAX(_set_at) AS max_set_at
     FROM appointment_events
     WHERE _status in ('Created', 'Transferred')
     GROUP BY _appointment_id ) B USING _appointment_id
  WHERE A._set_at = B.max_set_at;
  
  DROP TABLE appointment_events;
  