trunc(block_timestamp,'day') as date,

contract_name as collection,

count(distinct tx_id) as sales

from flow.core.fact_nft_sales x

join flow.core.dim_contract_labels y on x.nft_collection=y.event_contract

group by 1,2

having sales >100

order by 1 asc