with collections as (
select
ADDRESS_NAME as collection,
ADDRESS as m_ad
from solana.core.dim_labels
)
select
collection,
count(distinct tx_id) as sales_count,
sum(sales_amount) as volume,
avg(sales_amount) as average_nft_price,
count(distinct mint) as nfts,
count(distinct purchaser) as unique_buyers,
count(distinct seller) as unique_sellers
from solana.core.fact_nft_sales s,collections
where marketplace='hadeswap'
and SUCCEEDED = 'TRUE' and block_timestamp >= CURRENT_DATE - 7 AND m_ad=s.mint
GROUP BY collection
ORDER BY sales_count DESC
LIMIT 10