fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-09-26 04:41 PM copy copy
    -- forked from 2023-09-26 04:41 PM copy @ https://flipsidecrypto.xyz/edit/queries/809c0612-0f94-47b9-b2cc-acaaa0f6a6d9

    SELECT
    COUNT(from_address)Total_transactions,
    To_address AS contract,
    CASE WHEN LOWER(TO_ADDRESS) ='0xca28251acf27e55fdbfbf997397a28db122e70b2'
    THEN 'Base (BRKWY)'
    WHEN LOWER(TO_ADDRESS) ='0x88f685878261a3c29e6015e1560c01aa148e1d5b'
    THEN 'Base 2022-23 Expansion Pack (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0x78cda9b5fa2b74274c83747083f319c14584b53b'
    THEN 'Preseason Starter Pack (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0xabae4022c87bc74f4b2c525f52710fbd5822160f'
    THEN 'The Hunt for Stanley 2023 Debut LE (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0xa6536e1947e3c8317c2b13f7692936d52783e1a4'
    THEN 'Inaugural Founding Fan Base Pack (BRKWY)'
    ELSE 'other'
    END AS pack_drop

    FROM polygon.core.fact_transactions

    WHERE FROM_ADDRESS ='0x610123c1f5e34974c63343c84973cd5603b08e7c'
    AND pack_drop <> 'other'

    GROUP BY contract,pack_drop
    LIMIT 100



    Run a query to Download Data