COUNT(DISTINCT(BUYER_ADDRESS)) AS BUYERS,---The total number of unique buyers

COUNT(DISTINCT(SELLER_ADDRESS)) AS SELLERS---The total number of unique identifiers

FROM ethereum.core.ez_nft_sales---i us general tabel

WHERE PROJECT_NAME='cryptopunks' AND EVENT_TYPE='sale' AND BUYER_ADDRESS != '0x0000000000000000000000000000000000000000' AND SELLER_ADDRESS !='0x0000000000000000000000000000000000000000'