SELECT
count(distinct t.tx_hash) as transactions,
count(distinct signer_id) as Users,
sum(transaction_fee / power(10, 24)) as transaction_fees,
count(*) / count(distinct signer_id) as post_frequency
FROM
near.social.fact_decoded_actions
left outer join near.core.dim_address_labels on signer_id = address
left outer join near.core.fact_transactions t using (tx_hash)
WHERE
tx_status = 'Success';