with tab3 as ( with tab1 as (select address as "Holder", sum(balance/pow(10,6)) as "Holding Volume", 'Axelar' as "Chain", case when sum(balance/pow(10,6))<=1 then 'V<=1' when sum(balance/pow(10,6))>1 and sum(balance/pow(10,6))<=10 then '110 and sum(balance/pow(10,6))<=100 then '10100 and sum(balance/pow(10,6))<=1000 then '1001000 and sum(balance/pow(10,6))<=10000 then '1k10000 and sum(balance/pow(10,6))<=100000 then '10k100000 and sum(balance/pow(10,6))<=1000000 then '100k1000000 then 'V>1M' end as "Class" from axelar.core.fact_daily_balances where currency='uaxl' and address not in (select address from axelar.core.dim_labels) and date=current_date-1 group by 1), tab2 as (select address as "Holder", sum(balance/pow(10,decimal)) as "Holding Volume",'Osmosis' as "Chain", case when sum(balance/pow(10,6))<=1 then 'V<=1' when sum(balance/pow(10,6))>1 and sum(balance/pow(10,6))<=10 then '110 and sum(balance/pow(10,6))<=100 then '10100 and sum(balance/pow(10,6))<=1000 then '1001000 and sum(balance/pow(10,6))<=10000 then '1k10000 and sum(balance/pow(10,6))<=100000 then '10k100000 and sum(balance/pow(10,6))<=1000000 then '100k1000000 then 'V>1M' end as "Class" from osmosis.core.fact_daily_balances where currency='ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' and date=current_date-1 group by 1) select * from tab1 union all select * from tab2) select "Chain" ,count(distinct "Holder") as "Holder", "Class" from tab3 group by 1,3

Axelar: Interop Summit