select SPLIT(nft_collection,'.')[2] as nft_collection ,count(*) as today_total_sale from flow.core.fact_nft_sales

where date(block_timestamp)=CURRENT_DATE()

group by nft_collection

order by today_total_sale desc