count(distinct swapper) as seller_count

from sei.defi.fact_dex_swaps

where currency_in='usei' and tx_succeeded='true'

group by 1),

tab2 as (select platform, sum(amount_out)/pow(10,6) as buying_volume, count(distinct tx_id) as buying_count,

count(distinct swapper) as buyer_count

from sei.defi.fact_dex_swaps

where currency_out='usei' and tx_succeeded='true'

group by 1)

select tab1.platform as "DEX", selling_volume+buying_volume as "Swap Volume",

selling_volume AS "Selling Volume", buying_volume AS "Buying Volume", buying_volume-selling_volume as "Net Volume",

SELLING_COUNT AS "Selling Count", buying_count as "Buying Count",

selling_count+buying_count as "Swap Count", seller_count as "Seller Count", buyer_count as "Buyer Count"

from tab1 left join tab2 on tab1.platform=tab2.platform