s.from_currency,

avg(cast(replace(t.fee, 'uosmo', '') as int) * power(10, -6)) as avg_fee,

l.project_name

from osmosis.core.fact_swaps s

join osmosis.core.fact_transactions t on s.tx_id = t.tx_id

join osmosis.core.dim_labels l on s.from_currency = l.address

where fee ilike '%uosmo%'

and t.tx_status = 'SUCCEEDED'

group by 1,3

having avg_fee > 0

order by 2