date_trunc('day',block_timestamp)

,count(distinct s.tx_id)

,sum(price)

,player

from flow.core.ez_nft_sales s

join flow.core.dim_topshot_metadata m on s.nft_id = m.nft_id

where player = 'Donovan Mitchell'

group by 1, 4