ROUND((SUM(WALLETS) OVER(ORDER BY TX_DATE_DIFF) / SUM(WALLETS) OVER())*100,2) PERCENT

(SELECT ACCT, MIN(DATE_TRUNC('days', BLOCK_TIMESTAMP)) "DAY",

MAX(BLOCK_TIMESTAMP::DATE)-MIN(BLOCK_TIMESTAMP::DATE) TX_DATE_DIFF, COUNT(*) TXS

FROM

(SELECT BLOCK_TIMESTAMP, WALLET, BUYER,

CASE WHEN BUYER IS NOT NULL THEN BUYER ELSE WALLET END AS ACCT

FROM

(SELECT BLOCK_TIMESTAMP, t.TX_ID, AUTHORIZERS[0] WALLET, BUYER

FROM flow.core.fact_transactions t

LEFT JOIN (SELECT TX_ID, BUYER FROM flow.core.fact_nft_sales) s

ON t.TX_ID = s.TX_ID

WHERE t.TX_SUCCEEDED = TRUE))

WHERE ACCT NOT IN (SELECT ACCOUNT_ADDRESS FROM flow.core.dim_contract_labels)

GROUP BY 1)

WHERE TXS = 2

GROUP BY 1

ORDER BY 1