BUYER_ADDRESS ,

COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TX_HASH ELSE NULL END) AS nft_sales_count,

SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE_USD ELSE NULL END) AS total_sales_usd,

SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE ELSE NULL END) AS total_sales_eth

from ethereum.core.ez_nft_sales

where project_name = 'terraforms'

group by 1

order by 2 desc

offset 1 rows FETCH first 10 rows only