SELECT

BUYER_address AS BUYER,

COUNT (DISTINCT TX_HASH) AS TX_Count,

COUNT (DISTINCT TOKENID) AS Tokens_Count,

sum (price_usd) AS USDPrice,

sum (price) AS EthPrice

FROM ethereum.core.ez_nft_sales

WHERE BUYER_ADDRESS != '0x0000000000000000000000000000000000000000'

AND price is not null AND PRICE_USD is not null AND EVENT_TYPE='sale'

AND NFT_ADDRESS='0x455c732fee7b5c3b09531439b598ead4817d5274' --contract

GROUP BY 1

)

SELECT *

FROM a

ORDER by 3 DESC

LIMIT 20