-----------------------------------------------------bsc---------------------------------------------------------- WITH bsc as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from bsc.core.ez_token_transfers where contract_address = LOWER('0x9840652DC04fb9db2C43853633f0F62BE6f00f98') group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from bsc.core.ez_token_transfers where contract_address = LOWER('0x9840652DC04fb9db2C43853633f0F62BE6f00f98') 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 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from bsc.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 CGPT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M CGPT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'Bsc' as "Chain" from final_tab group by 1 order by 2 ), -----------------------------------------------------Ethereum-------------------------------------------------------- Ethereum as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from ethereum.core.ez_token_transfers where contract_address = '0x25931894a86d47441213199621f1f2994e1c39aa' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from ethereum.core.ez_token_transfers where contract_address = '0x25931894a86d47441213199621f1f2994e1c39aa' 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 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from ethereum.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 CGPT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M CGPT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'Ethereum' as "Chain" from final_tab group by 1 order by 2 ) select * from BSC union all select * from ethereum

🤖ChainGPT: Combining AI and Blockchain Technology