FROM_ADDRESS AS user_address,

COUNT(DISTINCT TX_HASH) AS transaction_count,

SUM(VALUE) AS total_value_transacted,

SUM(TX_FEE) AS total_fees_paid

FROM

bsc.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP BETWEEN '2024-08-01' AND '2024-08-31'

AND STATUS = 'SUCCESS' -- Assuming 'SUCCESS' indicates successful transactions

GROUP BY

FROM_ADDRESS

HAVING

COUNT(DISTINCT TX_HASH) > 0

ORDER BY

transaction_count DESC;