select

PROJECT_NAME,

count (distinct trader) as total_swapper,

count (distinct tx_id) as total_swap

from osmosis.core.fact_swaps inner join osmosis.core.dim_labels

on from_currency=address

where TO_CURRENCY not like '%pool%' or TO_CURRENCY is not null

and tx_status = 'SUCCEEDED'

group by 1

order by 2 desc

limit 15