with raw as (select m.*, t.status
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'))
select status,
count (distinct tx_hash) as number_txs
from raw
group by 1
order by 1 desc