greyswansupport
    Updated 2023-03-15
    with
    wash_guy_trans as (
    select
    date_trunc('month', block_timestamp) as NFT_month,
    seller,
    purchaser,
    marketplace,
    sales_amount,
    mint as mint2,
    tx_ID
    from
    solana.core.fact_nft_sales
    where
    purchaser = 'F5rZKF3hm297sXkfDZu3tTQjh69JrZSyWKxZz2AWgrsv'
    )
    select
    label,
    sum(sales_amount),
    count(Tx_ID),
    marketplace
    from wash_guy_trans
    left join solana.core.dim_labels on mint2=ADDRESS
    group by label, marketplace
    order by sum(sales_amount) desc


    Run a query to Download Data