from ethereum.core.ez_nft_mints m

left join ethereum.core.fact_transactions t

on m.tx_hash = t.tx_hash

where nft_address = lower('0xdfb57B6E16DDB97Aeb8847386989f4DCA7202146')),

unique_owners as (

select distinct nft_to_address as unique_owners,

count (tx_hash) as mints

from raw

group by 1

order by 2 desc)

select mints, count (unique_owners) from unique_owners group by 1