SELECT
    join_table.seq_coalesce AS col_one,
    join_table.seq_coalesce AS col_two
FROM
    seq_1_to_1_step_1 AS main_table
LEFT JOIN(
    SELECT
        tmp.seq AS seq_vanilla,
        COALESCE(tmp.seq) AS seq_coalesce
    FROM
        seq_1_to_1_step_1 tmp
) AS join_table
ON
    join_table.seq_vanilla = main_table.seq
WHERE
  main_table.seq = 1
GROUP BY
  main_table.seq;
