CREATE TABLE sequence_result_demo AS
SELECT sess.session_key as session_key,
       sess.remote_address as remote_address,
       sess.hit_count as hit_count,
       CollectAll(evt.event_id) as event_set,
       evt.rsp_timestamp as hit_timestamp,
       sess.tealeaf_replay as tealeaf_replay
    FROM tealeaf_session sess
        JOIN (SELECT sub_evt.*, sub_hit.rsp_timestamp FROM tealeaf_event sub_evt
                JOIN tealeaf_hit sub_hit ON (sub_evt.hit_key = sub_hit.hit_key)
              ORDER BY sub_hit.rsp_timestamp) evt
        ON (sess.session_key = evt.session_key)
    WHERE evt.event_id IN(274,284,55,151)
GROUP BY sess.session_key, sess.remote_address, sess.hit_count, evt.rsp_timestamp, sess.tealeaf_replay;