with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(amount) as input_vol from avalanche.core.ez_token_transfers where contract_address=lower('0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd') group by 1), tab2 as (select from_address, sum(amount) as output_vol from avalanche.core.ez_token_transfers where contract_address=lower('0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd') group by 1) select to_address 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.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 WHERE ADDRESS<>'0x1a731b2299e22fbac282e7094eda41046343cb51' AND ADDRESS<>'0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07' AND ADDRESS<>'0x799d4c5e577cf80221a076064a2054430d2af5cd' AND ADDRESS<>'0xd858ebaa943b4c2fb06ba0ba8920a132fd2410ee' AND ADDRESS <>'0x8f38558188fae593e8e6347f124351cf4fdd032d' 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 JOE' 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 JOE' 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

💎JOE Token Analysis