distinct signer_id as users,

count(distinct tx_hash) as post_count

from near.social.fact_decoded_actions

where node = 'post'

group by 1

order by 2 DESC

limit 10