COUNT(DISTINCT tx_id) AS total_transactions,

COUNT(tx_id) AS total_sales,

COUNT(CASE WHEN tx_succeeded = 'True' THEN tx_id END) AS successful_transactions,

COUNT(CASE WHEN tx_succeeded = 'False' THEN tx_id END) AS failed_transactions,

(COUNT(CASE WHEN tx_succeeded = 'True' THEN tx_id END) * 100.0) / COUNT(tx_id) AS success_rate,

(SELECT COUNT(DISTINCT trader_address)

FROM (

SELECT DISTINCT seller AS trader_address

FROM flow.nft.ez_nft_sales

UNION

SELECT DISTINCT buyer AS trader_address

FROM flow.nft.ez_nft_sales

) AS unique_traders) AS total_traders,

COUNT(DISTINCT nft_collection) AS total_assets,

COUNT(DISTINCT marketplace) AS total_platform

FROM

flow.nft.ez_nft_sales;