select *

from (

select

date_trunc('week', date) as week,

chain,

sum(REVENUE) as revenue

from external.defillama.fact_protocol_fees_revenue

where date >= current_date -90

group by 1 , 2

where revenue is not null

qualify row_number () over (partition by week order by revenue desc) <= 20

union all

select

date_trunc('week',day) as week,

'THORChain' as chain,

sum(liquidity_fees_usd) as revenue -- i consider just liquidity fee (or swap fee)

from thorchain.defi.fact_daily_earnings

where week >= current_date -90

group by 1

order by week desc