SUM (PRICE) AS ETHPRICE,

SUM (PRICE_USD) AS USDPRICE,

COUNT (DISTINCT TX_HASH) AS TXS

FROM ethereum.core.ez_nft_sales WHERE EVENT_TYPE ILIKE 'sale' AND PROJECT_NAME ILIKE 'cryptopunks' GROUP BY BUYER_ADDRESS),

SELLERS AS (SELECT SELLER_ADDRESS,

SUM (PRICE) AS ETHPRICE,

SUM (PRICE_USD) AS USDPRICE,

COUNT (DISTINCT TX_HASH) AS TXS

FROM ethereum.core.ez_nft_sales WHERE EVENT_TYPE ILIKE 'sale' AND PROJECT_NAME ILIKE 'cryptopunks' GROUP BY SELLER_ADDRESS)

SELECT 'BUYER' AS TYPE, AVG(ETHPRICE), AVG (USDPRICE), AVG (TXS) FROM BUYERS

SELECT 'SELLER' AS TYPE, AVG(ETHPRICE), AVG (USDPRICE), AVG (TXS) FROM SELLERS