feyikemiBridged Txn %
    Updated 2024-12-06
    WITH total_transactions AS (
    SELECT
    COUNT(DISTINCT tx_hash) AS total_txns
    FROM base.core.fact_transactions
    WHERE status = 'SUCCESS'
    ),
    bridged_transactions AS (
    SELECT
    COUNT(DISTINCT tx_hash) AS bridged_txns
    FROM base.defi.ez_bridge_activity
    )
    SELECT
    bridged_transactions.bridged_txns,
    total_transactions.total_txns,
    (bridged_transactions.bridged_txns / total_transactions.total_txns) * 100 AS percentage_bridged_txns
    FROM bridged_transactions
    CROSS JOIN total_transactions;

    QueryRunArchived: QueryRun has been archived