marketplace,

count(distinct(tx_id)) as sales_count,

sum(sales_amount) as sales_amount_total,

sum(fee / 1e9) as total_fee,

avg(fee / 1e9) as avg_fee

from solana.core.fact_nft_sales a

join solana.core.fact_transactions b

using (tx_id)

where b.block_timestamp::date >= '2022-10-15'

group by marketplace

order by avg_fee asc