select
contract_name as nft_collections,
count(*) as sales_count,
count(distinct buyer) as buyers_aount,
count(distinct seller) as selers_cpunt,
sum(price) as amount
from flow.core.fact_nft_sales join flow.core.dim_contract_labels on event_contract = nft_collection
where TX_SUCCEEDED = 'TRUE'
group by 1
order by 5 desc
limit 3