t0 as (

c.pool_id,

concat('#', c.pool_id::int, '-', b.project_name, '/', a.project_name) as pool_name

from osmosis.core.dim_liquidity_pools c

inner join osmosis.core.dim_tokens a

inner join osmosis.core.dim_tokens b

on a.address = c.assets[1].asset_address

and b.address = c.assets[0].asset_address

select

pool_id,

pool_name,

sum(fees_usd) as fee_usd,

avg(fees_usd) as average_fee_usd,

median(fees_usd) as median_fee_usd

from osmosis.core.fact_pool_fee_day

join t0 using(pool_id)

where block_date > current_date - interval '{{ months }} months'

group by 1, 2

having fee_usd > 0

order by 4 desc

limit 10