mz0111redux 17
    Updated 2022-11-03
    SELECT
    "NAME",
    case
    when "USD amount" between 0 and 10 then '0-10 USD'
    when "USD amount" between 10 and 100 then '10-100 USD'
    when "USD amount" between 100 and 1000 then '100-1000 USD'
    when "USD amount" between 1000 and 10000 then '1000-10000 USD'
    when "USD amount" > 10000 then 'MORE THAN 10000 USD'
    END AS "USD amount distribution",
    count( " bridge count")
    from
    (select
    DISTINCT tx_hash " bridge count",
    'ETH BRIDGE' AS "NAME",
    sum (AMOUNT_USD) AS "USD amount"
    from ethereum.core.ez_eth_transfers
    where ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    group by 1

    union ALL

    select
    DISTINCT tx_hash " bridge count",
    'USDC BRIDGE' AS "NAME",
    sum (AMOUNT_USD) "USD amount"
    from ethereum.core.ez_token_transfers
    where SYMBOL like 'USDC'
    and ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    group by 1
    union ALL

    select
    DISTINCT tx_hash " bridge count",
    'USDT BRIDGE' AS "NAME",
    sum (AMOUNT_USD) "USD amount"
    Run a query to Download Data