select
platform_name as market_place,
count(distinct(tx_hash)) as sales_count,
sum(tx_fee) as user_total_fee,
avg(tx_fee) as user_average_fee,
median(tx_fee) as user_median_fee,
sum(platform_fee) as platform_total_fee,
avg(platform_fee) as platform_avg_fee,
median(platform_fee) as platform_median_fee,
sum(platform_fee_usd) as platform_total_fee_usd,
avg(platform_fee_usd) as platform_avg_fee_usd,
median(platform_fee_usd) as platform_median_fee_usd
from ethereum.core.ez_nft_sales a
join ethereum.core.fact_transactions b
using(tx_hash)
where block_timestamp >= '2022-11-01'
group by market_place