date_trunc('{{Time_Interval}}',block_timestamp) as date,

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like 'Star Wars™: Volume III%' then 'Star Wars™ Volume III'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™: Volume II%' then 'Star Wars™ Volume II'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™: Volume I%' then 'Star Wars™ Volume I'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Yoda%' then 'Star Wars™ Special Editions Yoda'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Anakin Skywalker%' then 'Star Wars™ Special Editions Anakin Skywalker'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Boba Fett%' then 'Star Wars™ Special Editions Boba Fett,'

else 'not registered' end as collect,

count (distinct event_data:id) NFTs

from flow.core.fact_events

where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and event_type = 'Minted'

and block_timestamp>='2023-06-01'

and try_parse_json(EVENT_DATA:metadata)[7]:value:value ilike '%Star%'

GROUP by 1,2