Query editor
WITH GAS_RECIPIENT_STAT (address, first_txn, last_txn) AS (SELECT"from" AS address, min(block_time) AS FIRST_TXN, max(block_time) AS LAST_TXNFROM ethereum.transactionsWHERE "from" IN (SELECT address FROM dune.elric.result_nbtx_eth_wdl_step_2 WHERE clusterise_reason = 'Subsequent Gas Recipient')AND block_number >= 14116761 -- 2022-02-01GROUP BY 1)SELECTaddress, clusterise_reason, FIRST_TXN, LAST_TXNFROM dune.elric.result_nbtx_eth_wdl_step_2WHERE clusterise_reason != 'Subsequent Gas Recipient'UNIONSELECTgr.address, 'Subsequent Gas Recipient' AS clusterise_reason, grs.FIRST_TXN, grs.LAST_TXNFROM dune.elric.result_nbtx_eth_wdl_step_2 grINNER JOIN GAS_RECIPIENT_STAT grsON gr.address = grs.addressWHERE clusterise_reason = 'Subsequent Gas Recipient'