DISTINCT(FROM_ADDRESS) AS active_user_address,

COUNT(TX_HASH) AS transaction_count

FROM

blast.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP BETWEEN '2023-09-01' AND '2023-09-30'

GROUP BY

FROM_ADDRESS

HAVING

transaction_count > 0

ORDER BY

transaction_count DESC;