x.sql

WITH signer_lookup AS (
  SELECT
    tx_id,
    MAX(CASE WHEN signed THEN address END) AS signer
  FROM account_activity
  GROUP BY tx_id
)

SELECT
  a.*,
  s.signer
FROM
  account_activity a
LEFT JOIN
  signer_lookup s USING (tx_id)