with mint as (

select

event_data

from flow.core.fact_events

where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and event_data:metadata like '%Mickey and Friends: Volume I%'

and EVENT_TYPE = 'Minted'

and TX_SUCCEEDED = 'true'

)

select

count(DISTINCT event_data:id) as NFTs,

(NFTs * 39.99) as volume

from mint