saadiqBAYC
    Updated 2023-11-20
    -- forked from a2aec536-44a5-4897-ba91-d3a204422855
    -- forked from d74813b4-269c-4d86-b0f5-a6ec968d4aef
    SELECT
    sum(
    CASE
    WHEN contract_address IN ('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d') THEN 1
    ELSE 0
    END
    ) AS wallets,
    sum(
    CASE
    WHEN contract_address IN ('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d') THEN current_bal_unadj
    ELSE 0
    END
    ) AS items,
    sum(
    CASE
    WHEN contract_address IN (
    '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a',
    '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270',
    '0x99a9b7c1116f9ceeb1652de04d5969cce509b069'
    ) THEN 1
    ELSE 0
    END
    ) AS have_artblocks,
    concat(round(have_artblocks / wallets * 100, 1), '%') as perc_owning_ab,
    sum(
    CASE
    WHEN contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b') THEN 1
    ELSE 0
    END
    ) AS have_moonbirds,
    sum(
    CASE
    WHEN contract_address IN ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb') THEN 1
    ELSE 0
    Run a query to Download Data