BUYER_ADDRESS,

Purchase_Count

FROM (

SELECT

BUYER_ADDRESS,

COUNT(*) AS Purchase_Count

FROM ethereum.nft.ez_nft_sales

WHERE

nft_address = lower('0x4cd0ea8b1bdb5ab9249d96ccf3d8a0d3ada2bc76')

GROUP BY BUYER_ADDRESS

) AS BoonjiBuyerPurchases

WHERE Purchase_Count > 1

ORDER BY Purchase_Count DESC;