select

tx_id

from flow.core.fact_events

where event_contract like '%BBxBarbiePack%'

and EVENT_TYPE = 'Mint'

and TX_SUCCEEDED = 'true'

),

minters as (select

min(block_timestamp) as date,

event_data:to minter ,

count (distinct event_data:id) NFTs

from flow.core.fact_events

join mints using (tx_id)

where event_type = 'Deposit'

GROUP BY 2)

select

count (DISTINCT minter) as minters,

round(avg(nfts)) as avg_mints_per_minter

from minters