select event_contract, contract_name from flow.core.dim_contract_labels

select play_type, count(distinct a.nft_id) as nfts_count, count(distinct buyer) as total_wallets, sum(price) as total_sales_volume

from flow.core.fact_nft_sales a join symbol b on a.currency = b.event_contract left join flow.core.dim_allday_metadata c

on a.nft_id = c.nft_id

where play_type is not null and tx_succeeded = True and a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

group by play_type order by total_sales_volume desc

select distinct nft_collection from flow.core.dim_allday_metadata