DiamondPinnacle Pin Tracker: AOTC LE IV
    Updated 2024-04-05
    -- forked from Pinnacle Pin Tracker: AOTC LE III @ https://flipsidecrypto.xyz/edit/queries/72a531a7-7e07-40e5-8dfe-3bdf28dfbc6e

    -- forked from Pinnacle Pin Tracker: AOTC LE @ https://flipsidecrypto.xyz/edit/queries/1614d114-4597-444a-927e-051a0342659a

    -- forked from Pinnacle Pin Tracker: Up LE @ https://flipsidecrypto.xyz/edit/queries/87a5efca-24fa-445b-8fdf-008fd42c27d9

    WITH res AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    { 'Content-Type': 'application/json' },
    { 'sheets_id': '1-fZ31E_mYW_Shewwu_KI9OgZuj4_7UwTuuLvqSWlZ8k',
    'tab_name': 'Clones' }
    ) AS result
    FROM
    DUAL
    ),
    flattened_data AS (
    SELECT
    TO_TIMESTAMP_NTZ(f.value:"Timestamp") AS "Timestamp",
    f.value:"Username" :: VARCHAR AS "Username",
    f.value:"Serial Number" :: NUMBER AS "Serial Number",
    f.value:"Wallet Address" :: VARCHAR AS "Wallet Address",
    CASE
    WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-ANAK-S6' THEN 'Anakin Skywalker'
    WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-PADM-S6' THEN 'Padmé Amidala'
    WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-OBIW-S6' THEN 'Obi-Wan Kenobi'
    WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-COUN-S6' THEN 'Count Dooku'
    WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-JANG-S6' THEN 'Jango Fett'
    ELSE TRY_PARSE_JSON(f.value):"Render"::VARCHAR
    END AS "Render",
    f.value:"Total Minted" :: NUMBER AS "Total Minted",
    f.value:"Total Burned" :: NUMBER AS "Total Burned",
    f.value:"Variant" :: VARCHAR AS "Variant",
    f.value:"Edition" :: NUMBER AS "Edition",
    QueryRunArchived: QueryRun has been archived