with final_tab as (with tab4 as (with tab3 as (with tab1 as (select TX_TO, sum(amount) as input_vol from solana.core.fact_transfers where MINT='SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' group by 1), tab2 as (select TX_FROM, sum(amount) as output_vol from solana.core.fact_transfers where MINT='SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' 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" from tab3 WHERE ADDRESS<>'SHDWRWMZ6kmRG9CvKFSD7kVcnUqXMtd3SaMrLvWscbj' AND ADDRESS<>'SHDWRWMZ6kmRG9CvKFSD7kVcnUqXMtd3SaMrLvWscbj' AND ADDRESS not like 'SHDW%' ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from avalanche.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 SHDW' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M SHDW' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE tab4.address not in ('0x2a82ae142b2e62cb7d10b55e323acb1cab663a26' ,'0x2501c477d0a35545a387aa4a3eee4292a9a8b3f0') and "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance" from final_tab group by 1 order by 2

Analysis of Shadow Cloud