DB_v2 average amount claimed per address copy
    Updated 2023-11-14
    -- forked from 82088ee5-49d1-4cc2-b21e-08b1d39ca1a5

    select
    count(RECEIVER) as claimer,
    sum(amount / 1000000) as amount_claimed,
    amount_claimed / claimer as average_amount_claimed
    from
    terra.core.ez_transfers
    where
    sender = 'terra1un27xdwxcdt44xgeez7r5ysmc53tmfzyr7km0ydecqj7h5cuxcus5qk5uz'
    order by
    2 DESC


    Run a query to Download Data