COUNT(DISTINCT tx_id) AS "total transactions",

COUNT(DISTINCT CASE WHEN succeeded = 'True' THEN tx_id END) AS "Successful Transactions",

COUNT(DISTINCT CASE WHEN succeeded = 'False' THEN tx_id END) AS "Failed Transactions",

COUNT(DISTINCT mint) AS "Total NFT collections",

COUNT(DISTINCT marketplace) AS "Total NFT marketplace",

ROUND(COUNT(DISTINCT CASE WHEN succeeded = 'True' THEN tx_id END) * 100.0 / NULLIF(COUNT(DISTINCT tx_id), 0), 3) AS "Success Rate (%)",

(SELECT COUNT(DISTINCT "trader address")

FROM (

SELECT seller AS "trader address"

FROM solana.nft.fact_nft_sales

UNION

SELECT purchaser AS "trader address"

FROM solana.nft.fact_nft_sales

) AS "total traders") AS "total traders"

FROM

solana.nft.fact_nft_sales

WHERE

block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'