select *

from flow.core.fact_events

where event_type = 'Minted'

and event_contract = 'A.329feb3ab062d289.RaceDay_NFT'

and tx_succeeded = 1

count(distinct(a.event_data:to)) as minters_num,

count(distinct(a.event_data:id)) as mints_num

from flow.core.fact_events a

left outer join mints

on a.tx_id = mints.tx_id

and a.event_data:id = mints.event_data:id

and a.event_contract = mints.event_contract

where a.event_type = 'Deposit'

and a.tx_succeeded = 1