WITH sales_data AS (
SELECT
SUM(PRICE_USD) AS "total sales volume",
COUNT(DISTINCT TX_HASH) AS "NFT sales count",
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "total nft users",
COUNT(DISTINCT BUYER_ADDRESS) AS "total buyers",
COUNT(DISTINCT SELLER_ADDRESS) AS "total sellers",
COUNT(DISTINCT NFT_ADDRESS) AS "total nft collections"
FROM
base.nft.ez_nft_sales
)
SELECT
*,
"total sales volume" / NULLIF("NFT sales count", 0) AS "avg price per nft"
FROM
sales_data;