flipside

    8opethmetricsdao
    ML68opethmetricsdao
    Updated 2022-12-20
    with buyer_nft as (select ADDRESS_NAME as nft_collections , count(distinct TX_ID) as count , sum (SALES_AMOUNT) as amount from solana.core.fact_nft_sales inner join solana.core.dim_labels
    on solana.core.dim_labels.address=solana.core.fact_nft_sales.mint
    where PURCHASER='FkCFD5g5b1A9DsTJCuRYni9u53NsfF4Rs86orGBgVWMH'
    group by 1)

    select nft_collections,count,amount from buyer_nft
    Run a query to Download Data