nft_id as "Id",

count(distinct tx_id) as "Number of Sale"

from flow.core.ez_nft_sales

where

tx_succeeded = true and

nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

group by 1

order by 2 desc

limit 25