with tab1 as ( select CONTRACT_ADDRESS ,ORIGIN_FROM_ADDRESS ,RAW_AMOUNT ,TX_HASH from arbitrum.core.fact_token_transfers where ORIGIN_FUNCTION_SIGNATURE ='0xd5eed868' and ORIGIN_TO_ADDRESS='0x794a61358d6845594f94dc1db02a252b5b4814ad' and ORIGIN_FROM_ADDRESS=TO_ADDRESS and FROM_ADDRESS<>'0x0000000000000000000000000000000000000000' and BLOCK_TIMESTAMP>='2023-01-01' ), tab2 as ( select ADDRESS ,DECIMALS ,SYMBOL from arbitrum.core.dim_contracts where SYMBOL in ('USDC','USDT','DAI')), tab3 as ( select CONTRACT_ADDRESS ,ORIGIN_FROM_ADDRESS ,RAW_AMOUNT ,TX_HASH from optimism.core.fact_token_transfers where ORIGIN_FUNCTION_SIGNATURE ='0xd5eed868' and ORIGIN_TO_ADDRESS='0x794a61358d6845594f94dc1db02a252b5b4814ad' and ORIGIN_FROM_ADDRESS=TO_ADDRESS and FROM_ADDRESS<>'0x0000000000000000000000000000000000000000' and BLOCK_TIMESTAMP>='2023-01-01' ), tab4 as ( select ADDRESS ,DECIMALS ,SYMBOL from optimism.core.dim_contracts where SYMBOL in ('USDC','USDT','DAI')) select 'ARBITRUM CHAIN'as chain ,case when RAW_AMOUNT/pow(10,decimals)>0 and RAW_AMOUNT/pow(10,decimals)<=100 then 'below 100 $' when RAW_AMOUNT/pow(10,decimals)>100 and RAW_AMOUNT/pow(10,decimals)<=1000 then '100 ~1K $' when RAW_AMOUNT/pow(10,decimals)>1000 and RAW_AMOUNT/pow(10,decimals)<=10000 then '1K ~10K $' when RAW_AMOUNT/pow(10,decimals)>10000 and RAW_AMOUNT/pow(10,decimals)<=100000 then '10K ~100K $' when RAW_AMOUNT/pow(10,decimals)>100000 and RAW_AMOUNT/pow(10,decimals)<=1000000 then '100K ~1M $' when RAW_AMOUNT/pow(10,decimals)>1000000 then 'Up TO 1M $' end as dis_volume ,count(distinct ORIGIN_FROM_ADDRESS) as borrowers ,count(distinct TX_HASH) as borrow_count from tab1 left join tab2 on tab1.CONTRACT_ADDRESS=tab2.ADDRESS where dis_volume is not null group by 1,2 union all select 'OPTIMISM CHAIN'as chain ,case when RAW_AMOUNT/pow(10,decimals)>0 and RAW_AMOUNT/pow(10,decimals)<=100 then 'below 100 $' when RAW_AMOUNT/pow(10,decimals)>100 and RAW_AMOUNT/pow(10,decimals)<=1000 then '100 ~1K $' when RAW_AMOUNT/pow(10,decimals)>1000 and RAW_AMOUNT/pow(10,decimals)<=10000 then '1K ~10K $' when RAW_AMOUNT/pow(10,decimals)>10000 and RAW_AMOUNT/pow(10,decimals)<=100000 then '10K ~100K $' when RAW_AMOUNT/pow(10,decimals)>100000 and RAW_AMOUNT/pow(10,decimals)<=1000000 then '100K ~1M $' when RAW_AMOUNT/pow(10,decimals)>1000000 then 'Up To 1M $' end as dis_volume ,count(distinct ORIGIN_FROM_ADDRESS) as borrowers ,count(distinct TX_HASH) as borrow_count from tab3 left join tab4 on tab3.CONTRACT_ADDRESS=tab4.ADDRESS where dis_volume is not null group by 1,2

The battle between layer 2s