with table1 as (select distinct tx_from as staker from solana.core.fact_transfers where mint in ('HxhWkVpk5NS4Ltg5nij2G671CKXFRKPK8vy271Ub4uEK', 'CPwspzHc4bKtBQGNRhpRG9v3qRiPLWP28GrfZepwmBSz', '36VFoo1rQ7a1w45jBwHmr2sodnUUhRtL7K6fsx2tuMwb') and tx_to='BEYJqFx5G6whGmpJ4Ar9yyKfnDVBTcGWDSnJPPmsPWh6' and block_timestamp::date>='2022-10-01'), table2 as (with tab3 as (with tab1 as (select TX_TO, sum(amount) as input_vol from solana.core.fact_transfers where MINT='HxhWkVpk5NS4Ltg5nij2G671CKXFRKPK8vy271Ub4uEK' group by 1), tab2 as (select TX_FROM, sum(amount) as output_vol from solana.core.fact_transfers where MINT='HxhWkVpk5NS4Ltg5nij2G671CKXFRKPK8vy271Ub4uEK' group by 1) select TX_TO as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.TX_TO=tab2.TX_FROM) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance", case when input_volume-output_volume<=1 then 'V<=1 HXRO' when (input_volume-output_volume)>1 and (input_volume-output_volume)<=10 then '110 and (input_volume-output_volume)<=100 then '10100 and (input_volume-output_volume)<=1000 then '1001000 and (input_volume-output_volume)<=10000 then '1K10000 and (input_volume-output_volume)<=100000 then '10K100000 and (input_volume-output_volume)<=1000000 then '100K1M HXRO' end as "Class" from tab3) select "Class", count(distinct Staker) as "Staker Count" from table1 left join table2 on table1.staker=table2.address where "Balance">0 and "Balance" is not null group by 1 order by 2

Staking on Hxro.Finance