datavortext1 and t2
    Updated 2024-12-08
    WITH relayed_transactions AS (
    SELECT
    tx_hash
    FROM $query('6624cf9a-cb7d-49e4-aff3-b60ec4cf3b02')
    ),
    stake_transactions AS (
    SELECT
    tx_hash
    FROM $query('3e080519-bf92-483a-9ff1-7af637b491ac')
    )
    SELECT
    COUNT(DISTINCT r.tx_hash) AS total_relayed_stake_transactions
    FROM
    stake_transactions s
    JOIN
    relayed_transactions r
    ON s.tx_hash = r.tx_hash;



    QueryRunArchived: QueryRun has been archived