select

tx_id

,case

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

when event_data:metadata like '%Star Wars™: Volume I%' then 'Star Wars™: Volume I'

when event_data:metadata like '%Zoo-F-O%' then 'Zoo-F-O'

when event_data:metadata like '%Masters of the Universe™ Special Edition 2022%' then 'Masters of the Universe™ Special Edition 2022'

when event_data:metadata like '%Masters of the Universe™%' then 'Masters of the Universe™'

else 'not registered'

end as collection_type

from flow.core.fact_events

where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and event_type = 'Minted'

),

grouping as (

select

event_data:to as users

,tx_id

,collection_type

from flow.core.fact_events

join mints using (tx_id)

where event_type = 'Deposit'

select

collection_type

,count (distinct users) Minters

from grouping

group by 1