Updated 2023-06-18
    SELECT
    CASE WHEN value LIKE '%Luke Skywalker: Red 5%' THEN 'Luke Skywalker: Red 5'
    WHEN value LIKE '%Luke Skywalker: Farmboy%' THEN 'Luke Skywalker: Farmboy'
    WHEN value LIKE '%Leia Organa: Bespin Escape%' THEN 'Leia Organa: Bespin Escape'
    WHEN value LIKE '%Darth Vader: Sith Lord%' THEN 'Darth Vader: Sith Lord'
    WHEN value LIKE '%Jedi Lightsaber%' THEN 'Luke Skywalker Jedi Lightsaber'
    WHEN value LIKE '%Jedi Knight%' THEN 'Luke Skywalker Jedi knight'
    WHEN value LIKE '%Darth Vader: Damaged Helmet%' THEN 'Darth Vader: Damaged Helmet'

    ELSE NULL
    END NFT_Type,
    COUNT(*)
    FROM
    flow.core.fact_events,
    LATERAL FLATTEN(input => event_data) AS kv
    WHERE
    EVENT_CONTRACT = 'A.ca63ce22f0d6bdba.Cryptoys'
    AND event_type = 'Minted'
    AND tx_succeeded = 'true'
    AND block_timestamp > '2023-05-01'
    AND key ='metadata'
    AND value LIKE '%Star Wars%'
    AND NFT_Type IS NOT NULL

    GROUP BY NFT_type
    LIMIT 100;

    Run a query to Download Data