rajsSolana Transactions First Tx
    Updated 2022-07-28
    SELECT
    first_month,
    count(distinct user) as no_of_users
    FROM
    (
    SELECT
    signers[0] as user,
    count(*) as no_of_txs,
    date_trunc('month', min(block_timestamp)) as first_month
    from solana.core.fact_transactions
    where signers[0] IN
    (
    SELECT
    distinct address as address
    FROM
    (
    SELECT
    distinct purchaser as address
    from solana.core.fact_nft_sales
    where mint IN
    (
    SELECT
    address
    from solana.core.dim_labels
    where address_name = 'communi3: mad scientists'
    )

    union

    SELECT
    distinct purchaser as address
    from solana.core.fact_nft_mints
    where mint IN
    (
    SELECT
    address
    Run a query to Download Data