KaskoazulIt's the Catalina Whale Mixer - holders
    Updated 2022-05-18
    with purchasers as (
    select sales.purchaser as purchasers,
    count (sales.tx_id) as number_sales,
    sum (sales.sales_amount) as volume_sales
    from flipside_prod_db.solana.fact_nft_sales sales
    inner join flipside_prod_db.solana.dim_nft_metadata dat
    on sales.mint = dat.mint
    where dat.project_name = 'Catalina Whale Mixer'
    and sales.succeeded = 'TRUE'
    group by 1
    order by 1
    )

    select case
    when number_sales < 5 then 'Tier 1'
    when number_sales >= 5 and number_sales < 10 then 'Tier 2'
    when number_sales >= 10 then 'Tier 3'
    end as Tier,
    count (purchasers) as wallets
    from purchasers
    group by 1
    order by 2
    Run a query to Download Data