SELECT

avg(MARS_REWARDS / power(10, 6)) as avg_mars_claim,

median(MARS_REWARDS / power(10, 6)) as median_mars_claim,

count(DISTINCT tx_id) as claim_events,

COUNT(DISTINCT USER) as claimers

FROM osmosis.mars.ez_redbank_reward_claims