with osmo_price as ( select trunc(recorded_hour,'day') as day, avg(price) as avg_price from osmosis.core.ez_prices where day >= CURRENT_DATE - 180 and symbol = 'OSMO' group by 1) , luna_price as ( select trunc(block_timestamp,'day') as day, MEDIAN(to_amount/from_amount) as luna from terra.core.ez_swaps where from_currency = 'uluna'and to_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' and to_amount < 1e8 and from_amount < 1e8 AND block_timestamp >= CURRENT_DATE - 180 GROUP BY 1 order by 1) , terra as ( select trunc(block_timestamp,'day') as days, 'Terra' as chain, DELEGATOR_ADDRESS as user, count(DISTINCT tx_id) as count_tx, sum(amount*luna) as volume_usd from terra.core.ez_staking a left outer join luna_price b on a.block_timestamp::date = b.day where action = 'Delegate' and block_timestamp >= CURRENT_DATE - 180 group by 1,2,3) , Osmosis as ( select trunc(block_timestamp,'day') as days, 'Osmosis' as chain, TX_CALLER_ADDRESS as user, count(DISTINCT tx_id) as count_tx, sum(amount/pow(10,decimal)*avg_price) as volume_usd from osmosis.core.fact_staking a left outer join osmo_price b on a.block_timestamp::date = b.day where action = 'delegate' and block_timestamp >= CURRENT_DATE - 180 and currency = 'uosmo' and amount/pow(10,6) < 10000000 group by 1,2,3) , tb1 as ( select * from Osmosis UNION select * from terra) , tb2 as ( select chain, user, sum(count_tx) as total_tx, sum(volume_usd) as total_usd from tb1 group by 1,2) select chain, count(DISTINCT user) as count_user, case when total_usd <= 1 then 'a. Below 1$' when total_usd <= 10 then 'b. 1-10$' when total_usd <= 100 then 'c. 10-100$' when total_usd <= 500 then 'd. 100-500%' when total_usd <= 1000 then 'e. 500-1K$' when total_usd <= 5000 then 'f. 1K-5K' when total_usd <= 10000 then 'g. 5K-10K' when total_usd <= 50000 then 'h. 10K-50K' when total_usd <= 100000 then 'i. 50K-100K' when total_usd > 100000 then 'j. +100K' end as category from tb2 group by 1,3

Compare Staking on Osmosis Vs. Terra