tx_signer as active_user,

count(txn_hash) as num_txs

from flipside_prod_db.mdao_near.transactions

where block_timestamp > current_date - 30

group by 1

HAVING num_txs>1

order by 2 desc

LIMIT 100