ML66opethmetricsdao
Updated 2022-12-20
9
1
2
3
4
5
6
›
⌄
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='Enochf5h8U4GGrCyepYoJ5nwcy8kwNmNuzBdX1yb9Kwa'
group by 1)
select nft_collections,count,amount from buyer_nft
Run a query to Download Data