SELECT

COUNT(DISTINCT BUYER_ADDRESS) AS "total buyers",

COUNT(DISTINCT SELLER_ADDRESS) AS "total sellers"

FROM

base.nft.ez_nft_sales

SELECT

"total buyers",

"total sellers",

NULLIF("total buyers", 0) / NULLIF("total sellers", 0) AS "buyer to seller ratio"

FROM

buyer_seller_ratio;