, PLATFORM_NAME

, NFT_ADDRESS

, PROJECT_NAME

, EVENT_TYPE

, sum(PRICE) as TOTAL_PRICE

,sum(PRICE_USD) as TOTAL_PRICE_USD

FROM flipside_prod_db.ethereum_core.ez_nft_sales

WHERE PLATFORM_NAME ='nftx'

AND PROJECT_NAME = 'Cryptopunks' or PROJECT_NAME ='cryptopunks'

GROUP BY 1,2,3,4,5

;