select

tx_id as tx_id

,value as event

,value['value']['eventType']['qualifiedIdentifier'] as qualifiedIdentifier

,value['value']['fields'] as fields

,event:qualifiedIdentifier::number as evento

,event:eventIndex::number as index

from flow.core.fact_transactions,

lateral flatten( input => transaction_result['events'] )

select

qualifiedIdentifier,

count (distinct fields [0])

from txs

where qualifiedIdentifier ilike '%Minted%'

group by 1

order by 2 DESC